PA Change Order Fee Header OPEN (PA23500)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Fee Header OPEN (PA23500)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Change Order Fee Header OPEN
Physical Name: PA23500
Technical Name: PA_Change_Order_Fee_HDR_OPEN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
2PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
3PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
4PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
5PAVARTOTFEEAMT SearchPA Variance Total Fee AmountDLR17_RBS0_STR$Currency1017
6PAsequencenumber SearchPA Sequence Number 1INT5Integer24
7PAbegindate SearchPA Begin DatePA_DateDate48
8PAEnDate SearchPA End DateDTDate48
9PATOTPRJFEEAMT SearchPA Total Project Fee AmountDLR17_RBS0_STR$Currency1017
10PATOTRETNFEEAMT SearchPA Total Retainer Fee AmountDLR17_RBS0_STR$Currency1017
11PATOTRETNTNAMT SearchPA Total Retention AmountDLR17_RBS0_STR$Currency1017
12PATOTSRVCFEEAMT SearchPA Total Service Fee AmountDLR17_RBS0_STR$Currency1017
13PAClose_CB SearchPA Close CBCB_CloseBoolean20
14PAVARPRJFEEAMT SearchPA Variance Project Fee AmountDLR17_RBS0_STR$Currency1017
15PAVARRETFEEAMT SearchPA Variance Retainer Fee AmountDLR17_RBS0_STR$Currency1017
16PAVARETNFEEAMT SearchPA Variance Retention AmountDLR17_RBS0_STR$Currency1017
17PAVARSERVFEEAMT SearchPA Variance Service Fee AmountDLR17_RBS0_STR$Currency1017
18PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
19PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
20PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
21PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
22DEX_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 Change Order Fee Header OPEN (PA23500)

Leave a Reply

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