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