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 TypeSQL DB LengthKeyable Length
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
2PAACTUALBEGDATE SearchPA Actual Begin DateDATEDate46
3PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
4PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean20
5LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
6PA_Proj_Closing_Sequence SearchPA Proj Closing Sequence No.Long IntLong Integer48
7PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
8PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger20
9PASTAT SearchPA StatusPA_DDL_StatusInteger20
10PAFBeginDate SearchPA Forecast Begin DateDATEDate46
11PAFEndDate SearchPA Forecast End DateDATEDate46
12PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
13ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency1019
14PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
15PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency1017
16PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
17DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
18WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
19PAChecklist_Complete SearchPA Checklist CompleteCBBoolean20
20PAClose_CB SearchPA Close CBCB_CloseBoolean20
21DEX_ROW_ID Searchintint1010

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 *