PA Project Closing WORK Detail (PA11901)

azurecurveProductsProject Accounting (258)ProjectPA Project Closing WORK Detail (PA11901)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Closing WORK Detail
Physical Name: PA11901
Technical Name: PA_Project_Closing_LINE_WORK

Group Display Name: PA Project Closing Transactions
Group Technical Name: PA Project Closing Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
2PAACTUALBEGDATE SearchPA Actual Begin DateDATEDate6
3PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
4PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean0
5LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
6PA_Proj_Closing_Sequence SearchPA Proj Closing Sequence No.Long IntLong Integer8
7PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
8PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger0
9PASTAT SearchPA StatusPA_DDL_StatusInteger0
10PAFBeginDate SearchPA Forecast Begin DateDATEDate6
11PAFEndDate SearchPA Forecast End DateDATEDate6
12PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
13ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
14PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
15PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency17
16PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
17DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
18WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
19PAChecklist_Complete SearchPA Checklist CompleteCBBoolean0
20PAClose_CB SearchPA Close CBCB_CloseBoolean0
21DEX_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 WORK Detail (PA11901)

Leave a Reply

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