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:

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 TypeLength
1PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
2PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
3PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
4PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
5PAVARTOTFEEAMT SearchPA Variance Total Fee AmountDLR17_RBS0_STR$Currency17
6PAsequencenumber SearchPA Sequence Number 1INT5Integer4
7PAbegindate SearchPA Begin DatePA_DateDate8
8PAEnDate SearchPA End DateDTDate8
9PATOTPRJFEEAMT SearchPA Total Project Fee AmountDLR17_RBS0_STR$Currency17
10PATOTRETNFEEAMT SearchPA Total Retainer Fee AmountDLR17_RBS0_STR$Currency17
11PATOTRETNTNAMT SearchPA Total Retention AmountDLR17_RBS0_STR$Currency17
12PATOTSRVCFEEAMT SearchPA Total Service Fee AmountDLR17_RBS0_STR$Currency17
13PAClose_CB SearchPA Close CBCB_CloseBoolean0
14PAVARPRJFEEAMT SearchPA Variance Project Fee AmountDLR17_RBS0_STR$Currency17
15PAVARRETFEEAMT SearchPA Variance Retainer Fee AmountDLR17_RBS0_STR$Currency17
16PAVARETNFEEAMT SearchPA Variance Retention AmountDLR17_RBS0_STR$Currency17
17PAVARSERVFEEAMT SearchPA Variance Service Fee AmountDLR17_RBS0_STR$Currency17
18PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency17
19PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
20PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency17
21PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency17
22DEX_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 Change Order Fee Header OPEN (PA23500)

Leave a Reply

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