PA Project Closing History Budget (PA11905)

azurecurveProductsProject Accounting (258)ProjectPA Project Closing History Budget (PA11905)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA11905

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Closing History Budget
Physical Name: PA11905
Technical Name: PA_Project_Closing_LINE_HIST_Budget

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PA_Proj_Closing_Sequence SearchPA Proj Closing Sequence No.Long IntLong Integer8
2PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
3JRNENTRY SearchJournal EntryLI8_U0Long Integer8
4PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
5PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
6PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
7PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
8PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger0
9PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer14
10PABBillingsIDX SearchPA Billings IDXLI_14Long Integer14
11PABBIEEIDX SearchPA BIEE IDXLI_14Long Integer14
12PABEIEBIDX SearchPA EIEB IDXLI_14Long Integer14
13PABLossIDX SearchPA Loss IDXLI_14Long Integer14
14PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
15PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
16PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
17PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
18PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
19PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
20PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
21PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency17
22PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency17
23PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency17
24PAPrevCost SearchPA Prev CostPA_DLR17_RBS0_STR$Currency17
25PAPrevBIEEAmount SearchPA Prev BIEE AmountPA_DLR17_RBS0_STR$Currency17
26PAPrevEIEBAmount SearchPA Prev EIEB AmountPA_DLR17_RBS0_STR$Currency17
27PAPrevBillings SearchPA Prev BillingsPA_DLR17_RBS0_STR$Currency17
28PAPrevLossAmount SearchPA Prev Loss AmountPA_DLR17_RBS0_STR$Currency17
29PAPrevRecognizedRev SearchPA Prev Recognized RevenuePA_DLR17_RBS0_STR$Currency17
30PAPrevEarnings SearchPA Prev EarningsPA_DLR17_RBS0_STR$Currency17
31PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency17
32DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsProject Accounting (258)ProjectPA Project Closing History Budget (PA11905)

Leave a Reply

Your email address will not be published. Required fields are marked *