Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA23501
Product: Project Accounting (258)
Series: Project
Display Name: PA Change Order Fee Detail OPEN 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.
Physical Name: PA23501
Technical Name: PA_Change_Order_Fee_DTL_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PACONTNUMBER PA Contract Number STR10_LBAU String 10 2 PACHGORDNO PA Change Order Number STR17_LBAU String 17 3 PAPROJNUMBER PA Project Number STR15_LBAU String 15 4 PALineItemSeq PA Line Item Sequence LI_Sequence_Number Long Integer 10 5 PAFeeID PA Fee ID STR15_LBAU String 15 6 PAFeeType PA Fee Type PA_DDL_Fee_Type Integer 0 7 PAPREVFEEAMT PA Prev Fee Amount DLR17_RBS0_STR$ Currency 17 8 PAVARFEESAMT PA Variance Fee Amount DLR17_RBS0_STR$ Currency 17 9 PAFeeAmount PA Fee Amount DLR17_RBSO_STR$ Currency 17 10 PA_Prev_Fee_Percent PA Prev Fee Percent DLR5_%2 Currency 8 11 PAVARFEEPRCNT PA Variance Fee Percent DLR5_%2 Currency 8 12 PAFeePercent PA Fee Percent DLR5_%2 Currency 8 13 PAFeeToUse PA Fee To Use GB Integer 0 14 PASales_Tax_Options PA Sales Tax Options PA_DDL_Tax_Options_Sales Integer 0 15 PAbilltaxscheduleid PA Billing Tax Schedule ID STR15_Tax_Schedule_ID String 15 16 PAPREVBILLTXSCHED PA Prev Billing Tax Schedule ID STR15_Tax_Schedule_ID String 15 17 PAbegindate PA Begin Date PA_Date Date 8 18 PAPREVBEGINDT PA Prev Begin Date PA_Date Date 8 19 PAEnDate PA End Date DT Date 8 20 PAPREVENDDT PA Prev End Date PA_Date Date 8 21 PAFrequency PA Frequency PA_DDL_Frequency Integer 0 22 PAPREVFREQ PA Prev Frequency PA_DDL_Frequency Integer 0 23 STRTDATE Start Date DT Date 8 24 ENDDATE End Date DT Date 8 25 PARenew PA Renew PA_CB_Renew Boolean 0 26 PARenewal_Date PA Renewal Date PA_Date Date 8 27 PATotAmt PA Total Amount DLR17_RBS0_STR$ Currency 17 28 PAPREVTOTAMT PA Prev Total Amount DLR17_RBS0_STR$ Currency 17 29 PA_Renew_Day PA Renew Day INT2_U0 Integer 2 30 PA_Renew_Month PA Renew Month INT2_U0 Integer 2 31 PAsequencenumber PA Sequence Number 1 INT5 Integer 4 32 TM_AR_Fee_SRC TM AR Fee SRC DDL_Fee_Account_Source Integer 0 33 TM_Prj_Deferred_Rev_Fee_ TM Prj Deferred Rev Fee SRC DDL_Fee_Account_Source Integer 0 34 TM_Prj_Rev_Fee_SRC TM Prj Rev Fee SRC DDL_Fee_Account_Source Integer 0 35 TM_BIEE_Fee_SRC TM BIEE Fee SRC DDL_Fee_Account_Source Integer 0 36 TM_EIEB_Fee_SRC TM EIEB Fee SRC DDL_Fee_Account_Source Integer 0 37 PAFF_AR_Fee_SRC FF AR Fee SRC DDL_Fee_Account_Source Integer 0 38 FF_Prj_Billings_Fee_SRC FF Prj Billings Fee SRC DDL_Fee_Account_Source Integer 0 39 FF_Prj_Rev_Fee_SRC FF Prj Rev Fee SRC DDL_Fee_Account_Source Integer 0 40 FF_Retention_Fee_SRC FF Retention Fee SRC DDL_Fee_Account_Source Integer 0 41 FF_WIP_Fee_SRC FF WIP Fee SRC DDL_Fee_Account_Source Integer 0 42 FF_Prj_Deferred_Rev_Fee_ FF Prj Deferred Rev Fee SRC DDL_Fee_Account_Source Integer 0 43 FF_BIEE_Fee_SRC FF BIEE Fee SRC DDL_Fee_Account_Source Integer 0 44 FF_EIEB_Fee_SRC FF EIEB Fee SRC DDL_Fee_Account_Source Integer 0 45 PAtotcbts PA Label Checkbox - TS CB Boolean 0 46 PAtotcbEL PA Label Checkbox - EL CB Boolean 0 47 PAtotcbML PA Label Checkbox - ML CB Boolean 0 48 PAtotcbvi PA Label Checkbox - VI CB Boolean 0 49 PAtotcber PA Label Checkbox - EE CB Boolean 0 50 PAtotcbinv PA Label Checkbox - INV CB Boolean 0 51 PAbillnoteidx PA Billing Note Index DLR14 Currency 14 52 PAPosted_Project_Fee PA Actual Project Fee Amount PA_DLR17_RBS0_STR$ Currency 17 53 PAPosted_Retainer_Fee PA Actual Retainer Fee Amount PA_DLR17_RBS0_STR$ Currency 17 54 PAPOSTRETAMT PA Actual Retention Amount PA_DLR17_RBS0_STR$ Currency 17 55 PAPosted_Service_Fee PA Actual Service Fee Amount PA_DLR17_RBS0_STR$ Currency 17 56 DEX_ROW_ID int int 10