Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA23401
Product: Project Accounting (258)
Series: Project
Display Name: PA Change Order 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: PA23401
Technical Name: PA_Change_Order_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 PACOTRKCHGBY PA CO Track Changes By PA_DDL_CO_Track_Changes Integer 0 4 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 5 PAPROJNUMBER PA Project Number STR15_LBAU String 15 6 PATU PA Transaction Usage PA_DDL_Transaction_Usage Integer 0 7 PACOSTCATID PA Cost Category ID STR15_Cost_Category_ID String 15 8 PALineItemSeq PA Line Item Sequence LI_Sequence_Number Long Integer 10 9 PAUnit_of_Measure PA Unit of Measure U_Of_M String 8 10 UOMSCHDL U Of M Schedule STR10_Schedule String 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['PA Change Order Detail OPEN'].UOMSCHDL AS 'PA Change Order Detail OPEN-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA23401 AS ['PA Change Order Detail OPEN']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA Change Order Detail OPEN'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL11 PAPREVBEGINDT PA Prev Begin Date PA_Date Date 8 12 PAbegindate PA Begin Date PA_Date Date 8 13 PAPREVENDDT PA Prev End Date PA_Date Date 8 14 PAEnDate PA End Date DT Date 8 15 PAPREVPYCDESLY PA Prev Pay Code Salary STR6_Payroll_Code String 6 16 PAPay_Code_Salary PA Pay Code Salary STR6_Payroll_Code String 6 17 PAPREVPYCODEHOURLY PA Prev Pay Code Hourly STR6_Payroll_Code String 6 18 PAPay_Code_Hourly PA Pay Code Hourly STR6_Payroll_Code String 6 19 PAProfitType PA Profit Type PA_DDL_Profit_Type Integer 0 20 PAbllngtype PA Billing Type PA_DDL_Billing_Type Integer 0 21 PAPREVPURCHTXOPT PA Prev Purchase Tax Options PA_DDL_Tax_Options_Purchase Integer 0 22 PAPurchase_Tax_Options PA Purchase Tax Options PA_DDL_Tax_Options_Purchase Integer 0 23 PAPREVCOSTXSCHED PA Prev Cost Tax Schedule ID STR15_Tax_Schedule_ID String 15 24 PAPURCHTAXSCHED PA Purchase Tax Schedule ID STR15_Tax_Schedule_ID String 15 25 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 0 26 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 27 PAPREVSALESTXOPT PA Prev Sales Tax Options PA_DDL_Tax_Options_Sales Integer 0 28 PASales_Tax_Options PA Sales Tax Options PA_DDL_Tax_Options_Sales Integer 0 29 PAPREVBILLTXSCHED PA Prev Billing Tax Schedule ID STR15_Tax_Schedule_ID String 15 30 PAbilltaxscheduleid PA Billing Tax Schedule ID STR15_Tax_Schedule_ID String 15 31 PAVarianceQty PA Variance Qty DLR15_RBS2 Currency 15 32 PAQtyQ PA Quantity PA_DLR15_RBS0_STR Currency 15 33 PAVarianceCosts PA Variance Costs DLR17_RBSO_STR$ Currency 17 34 PAUNITCOST PA Unit Cost PA_DLR17_RBS0_UTR$ Currency 17 35 PAVARTOTCOST PA Variance Total Cost DLR17_RBS0_STR$ Currency 17 36 PAVAROVERHDAMT PA Variance Total Overhead Amount DLR17_RBS0_STR$ Currency 17 37 PATOTALOVERH PA Total Overhead DLR17_RBS0_UTR$ Currency 17 38 PAVAROVERHDPRCNT PA Variance Overhead Percent DLR5_%2 Currency 8 39 PAOverheaPercentage PA Overhead Percentage DLR5_%2 Currency 8 40 PAVAROVRHDUNIT PA Variance Overhead Per Unit DLR17_RBS0_STR$ Currency 17 41 PAOvhdAmtPerUnit PA Overhead Amount Per Unit DLR17_RBS0_UTR$ Currency 17 42 PATOTCST PA Total Cost PA_DLR17_RBS0_STR$ Currency 17 43 PAVARMUPRCNT PA Variance Markup Percentage DLR5_%2 Currency 8 44 PAProfitPercent PA Profit Percent DLR5_%2 Currency 8 45 PAVARPROFAMT PA Variance Profit Amount DLR17_RBS0_STR$ Currency 17 46 PAProfitAmount PA Profit Amount DLR17_RBS0_UTR$ Currency 17 47 PAVARTOTLPROF PA Variance Total Profit DLR17_RBS0_STR$ Currency 17 48 PATotalProfit PA Total Profit DLR17_RBS0_UTR$ Currency 17 49 PAVARTOTBILLINGS PA Variance Total Billings DLR17_RBS0_STR$ Currency 17 50 PAtotbillings PA Total Billings DLR17_RBS0_UTR$ Currency 17 51 PAORIGBUDGTAMT PA Original Budget Amount DLR17_RBS0_UTR$ Currency 17 52 PAROGPROJAMT PA Original Project Amount DLR17_RBS0_UTR$ Currency 17 53 PAVARPROJAMT PA Variance Project Amount DLR17_RBS0_STR$ Currency 17 54 PAProject_Amount PA Project Amount DLR17_RBS0_UTR$ Currency 17 55 PAPREVPROJAMT PA Prev Project Amount DLR17_RBS0_UTR$ Currency 17 56 PAPREVBASEQTY PA Prev Base Qty PA_DLR15_RBS0_STR Currency 15 57 PABase_Qty PA Base Qty PA_DLR15_RBS0_STR Currency 15 58 PAPREVBSEUNTCST PA Prev Base Unit Cost DLR17_RBS0_UTR$ Currency 17 59 PABase_Unit_Cost PA Base Unit Cost PA_DLR17_RBS0_STR$ Currency 17 60 PAPREVBSOVERHDCST PA Prev Base Overhead Cost DLR17_RBS0_UTR$ Currency 17 61 PABaseOvhdCost PA Base Overhead Cost DLR17_RBS0_UTR$ Currency 17 62 PAPREVBSPROFAMT PA Prev Base Profit Amount DLR17_RBS0_UTR$ Currency 17 63 PABaseProfitAmount PA Base Profit Amount DLR17_RBS0_UTR$ Currency 17 64 PAPROPQUOTEAMT PA Propose Quote Amount DLR17_RBS0_UTR$ Currency 17 65 PAFINQUOTEAMT PA Final Quote Amount DLR17_RBS0_UTR$ Currency 17 66 PAQUOTEPREPBY PA Quote Prepared By STR20_LB String 20 67 PAQUOTEAPPRVBY PA Quote Approved By STR20_LB String 20 68 PAREVBUDGTAMT PA Revise Budget Amount DLR17_RBS0_UTR$ Currency 17 69 PAREVPROJAMT PA Revise Project Amount DLR17_RBS0_UTR$ Currency 17 70 PAsequencenumber PA Sequence Number 1 INT5 Integer 4 71 APPRVLDT Approval Date DATE Date 6 72 PAClose_CB PA Close CB CB_Close Boolean 0 73 PAPostedQty PA Actual Qty PA_DLR15_RBS0_STR Currency 15 74 PAPostedTotalCostN PA Actual Total Cost PA_DLR17_RBS0_STR$ Currency 17 75 PAPosted_Overhead PA Actual Overhead PA_DLR17_RBS0_STR$ Currency 17 76 PAPostedProfitN PA Actual Profit PA_DLR17_RBS0_STR$ Currency 17 77 PAPosted_Tax_Amount PA Actual Tax Amount PA_DLR17_RBS0_STR$ Currency 17 78 PAPosted_Accr_RevN PA Actual Accrued Revenues PA_DLR17_RBS0_STR$ Currency 17 79 PAPostRecogRevN PA Actual Recognized Revenue PA_DLR17_RBS0_STR$ Currency 17 80 PAPOSBIEEAMOUNT PA Actual BIEE Amount DLR17_RBS0_UTR$ Currency 17 81 PAPOSEIEBAMOUNT PA Actual EIEB Amount DLR17_RBS0_UTR$ Currency 17 82 PApostbillamt PA Actual Billed Amount DLR17_RBS0_UTR$ Currency 17 83 PA_Actual_Receipts_Amoun PA Actual Receipts Amount PA_DLR17_RBS0_STR$ Currency 17 84 PAPostedBillingsN PA Actual Billings PA_DLR17_RBS0_STR$ Currency 17 85 PAPostedDiscDolAmtN PA Actual Discount Dollar Amount PA_DLR17_RBS0_STR$ Currency 17 86 PAPosted_Sales_Tax_Amou PA Actual Sales Tax Amount PA_DLR17_RBS0_STR$ Currency 17 87 ActualWriteOffAmount Actual Write Off Amount DLR17_RBS0_UTR$ Currency 17 88 ActualDiscTakenAmount Actual Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 89 PAPostedTaxPaidN PA Actual Tax Paid PA_DLR17_RBS0_STR$ Currency 17 90 PAPOSTRETAMT PA Actual Retention Amount PA_DLR17_RBS0_STR$ Currency 17 91 PAActualWOTaxAmt PA Actual Write Off Tax Amount PA_DLR17_RBS0_STR$ Currency 17 92 PAActualTermsTakenTax PA Actual Terms Taken Tax Amt PA_DLR17_RBS0_STR$ Currency 17 93 DEX_ROW_ID int int 10