PA Project Closing WORK Detail (PA11901)

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

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	16	15
2	PAACTUALBEGDATE	PA Actual Begin Date	DATE	Date	4	6
3	PACONTNUMBER	PA Contract Number	STR10_LBAU	String	12	10
4	PASegmentCB	PA Segment CB	PA_CB_Segment	Boolean	2	0
5	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
6	PA_Proj_Closing_Sequence	PA Proj Closing Sequence No.	Long Int	Long Integer	4	8
7	PAProjectType	PA Project Type	PA_DDL_Project_Type	Integer	2	0
8	PAAcctgMethod	PA Accounting Method	PA_DDL_Accounting_Method	Integer	2	0
9	PASTAT	PA Status	PA_DDL_Status	Integer	2	0
10	PAFBeginDate	PA Forecast Begin Date	DATE	Date	4	6
11	PAFEndDate	PA Forecast End Date	DATE	Date	4	6
12	PAProject_Amount	PA Project Amount	DLR17_RBS0_UTR$	Currency	10	17
13	ACCTAMNT	Account Amount	DLR19_RBS0_UTR$	Currency	10	19
14	PAPostedBillingsN	PA Actual Billings	PA_DLR17_RBS0_STR$	Currency	10	17
15	PA_Receipts_Amount	PA Receipts Amount	PA_DLR17_RBS0_STR$	Currency	10	17
16	PAPostedTotalCostN	PA Actual Total Cost	PA_DLR17_RBS0_STR$	Currency	10	17
17	DISTKNAM	Discount Taken Amount	DLR17_RBS0_UTR$	Currency	10	17
18	WROFAMNT	Write Off Amount	DLR17_RBS0_STR$	Currency	10	17
19	PAChecklist_Complete	PA Checklist Complete	CB	Boolean	2	0
20	PAClose_CB	PA Close CB	CB_Close	Boolean	2	0
21	DEX_ROW_ID		int	int	10	10
	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.