Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA11904
Product: Project Accounting (258)
Series: Project
Display Name: PA Project Closing Work Fee 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: PA11904
Technical Name: PA_Project_Closing_LINE_WORK_FeeSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PA_Proj_Closing_Sequence PA Proj Closing Sequence No. Long Int Long Integer 8 2 PALineItemSeq PA Line Item Sequence LI_Sequence_Number Long Integer 10 3 JRNENTRY Journal Entry LI8_U0 Long Integer 8 4 PACONTNUMBER PA Contract Number STR10_LBAU String 10 5 PAPROJNUMBER PA Project Number STR15_LBAU String 15 6 PAFeeID PA Fee ID STR15_LBAU String 15 7 PAFeeType PA Fee Type PA_DDL_Fee_Type Integer 0 8 PAFeeAmount PA Fee Amount DLR17_RBSO_STR$ Currency 17 9 PACGBWIPIDX PA WIP IDX LI_14 Long Integer 14 10 PABBillingsIDX PA Billings IDX LI_14 Long Integer 14 11 PARev_IDX PA Revenue IDX LI_14 Long Integer 14 12 PABBIEEIDX PA BIEE IDX LI_14 Long Integer 14 13 PABEIEBIDX PA EIEB IDX LI_14 Long Integer 14 14 PAPostedBillingsN PA Actual Billings PA_DLR17_RBS0_STR$ Currency 17 15 PAPostRecogRevN PA Actual Recognized Revenue PA_DLR17_RBS0_STR$ Currency 17 16 PAPOSBIEEAMOUNT PA Actual BIEE Amount DLR17_RBS0_UTR$ Currency 17 17 PAPOSEIEBAMOUNT PA Actual EIEB Amount DLR17_RBS0_UTR$ Currency 17 18 PAPrevBillings PA Prev Billings PA_DLR17_RBS0_STR$ Currency 17 19 PAPrevBIEEAmount PA Prev BIEE Amount PA_DLR17_RBS0_STR$ Currency 17 20 PAPrevEIEBAmount PA Prev EIEB Amount PA_DLR17_RBS0_STR$ Currency 17 21 PAPrevRecognizedRev PA Prev Recognized Revenue PA_DLR17_RBS0_STR$ Currency 17 22 PAPrevEarnings PA Prev Earnings PA_DLR17_RBS0_STR$ Currency 17 23 PAPosted_Earnings PA Actual Earnings PA_DLR17_RBS0_STR$ Currency 17 24 DEX_ROW_ID int int 10