Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA12001
Product: Project Accounting (258)
Series:
Display Name: PA Change Order Detail WORK
Physical Name: PA12001
Technical Name: PA_Change_Order_DTL_WORKSeq 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 WORK'].UOMSCHDL AS 'PA Change Order Detail WORK-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA12001 AS ['PA Change Order Detail WORK']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA Change Order Detail WORK'].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 PAPREVQTY PA Prev Quantity Currency PA_DLR15_RBS0_STR 15 34 PAVarianceCosts PA Variance Costs Currency DLR17_RBSO_STR$ 17 35 PAUNITCOST PA Unit Cost Currency PA_DLR17_RBS0_UTR$ 17 36 PAPREVUNITCOST PA Prev Unit Cost Currency PA_DLR17_RBS0_UTR$ 17 37 PAVARTOTCOST PA Variance Total Cost Currency DLR17_RBS0_STR$ 17 38 PAVAROVERHDAMT PA Variance Total Overhead Amount Currency DLR17_RBS0_STR$ 17 39 PATOTALOVERH PA Total Overhead Currency DLR17_RBS0_UTR$ 17 40 PAVAROVERHDPRCNT PA Variance Overhead Percent Currency DLR5_%2 8 41 PAOverheaPercentage PA Overhead Percentage Currency DLR5_%2 8 42 PAPREVOVRHDPRCNT PA Prev Overhead Percentage Currency DLR5_%2 8 43 PAPREVTOTOVEHD PA Prev Total Overhead Currency DLR17_RBS0_UTR$ 17 44 PAVAROVRHDUNIT PA Variance Overhead Per Unit Currency DLR17_RBS0_STR$ 17 45 PAOvhdAmtPerUnit PA Overhead Amount Per Unit Currency DLR17_RBS0_UTR$ 17 46 PAPREVOVEHDUNIT PA Prev Overhead Amount Per Unit Currency DLR17_RBS0_UTR$ 17 47 PATOTCST PA Total Cost Currency PA_DLR17_RBS0_STR$ 17 48 PAPREVTOTCOST PA Prev Total Cost Currency DLR17_RBS0_UTR$ 17 49 PAVARMUPRCNT PA Variance Markup Percentage Currency DLR5_%2 8 50 PAProfitPercent PA Profit Percent Currency DLR5_%2 8 51 PAPREVPROFPRCNT PA Prev Profit Percent Currency DLR5_%2 8 52 PAVARPROFAMT PA Variance Profit Amount Currency DLR17_RBS0_STR$ 17 53 PAProfitAmount PA Profit Amount Currency DLR17_RBS0_UTR$ 17 54 PAPRVPROFITAMT PA Prev Profit Amount Currency DLR17_RBS0_UTR$ 17 55 PAVARTOTLPROF PA Variance Total Profit Currency DLR17_RBS0_STR$ 17 56 PATotalProfit PA Total Profit Currency DLR17_RBS0_UTR$ 17 57 PAPREVTOTPROF PA Prev Total Profit Currency DLR17_RBS0_UTR$ 17 58 PAVARTOTBILLINGS PA Variance Total Billings Currency DLR17_RBS0_STR$ 17 59 PAtotbillings PA Total Billings Currency DLR17_RBS0_UTR$ 17 60 PAPREVTOTBILL PA Prev Total Billings Currency DLR17_RBS0_UTR$ 17 61 PAORIGBUDGTAMT PA Original Budget Amount Currency DLR17_RBS0_UTR$ 17 62 PAROGPROJAMT PA Original Project Amount Currency DLR17_RBS0_UTR$ 17 63 PAProject_Amount PA Project Amount Currency DLR17_RBS0_UTR$ 17 64 PAPREVPROJAMT PA Prev Project Amount Currency DLR17_RBS0_UTR$ 17 65 PAVARPROJAMT PA Variance Project Amount Currency DLR17_RBS0_STR$ 17 66 PAPREVBASEQTY PA Prev Base Qty Currency PA_DLR15_RBS0_STR 15 67 PABase_Qty PA Base Qty Currency PA_DLR15_RBS0_STR 15 68 PAPREVBSEUNTCST PA Prev Base Unit Cost Currency DLR17_RBS0_UTR$ 17 69 PABase_Unit_Cost PA Base Unit Cost Currency PA_DLR17_RBS0_STR$ 17 70 PAPREVBSOVERHDCST PA Prev Base Overhead Cost Currency DLR17_RBS0_UTR$ 17 71 PABaseOvhdCost PA Base Overhead Cost Currency DLR17_RBS0_UTR$ 17 72 PAPREVBSPROFAMT PA Prev Base Profit Amount Currency DLR17_RBS0_UTR$ 17 73 PABaseProfitAmount PA Base Profit Amount Currency DLR17_RBS0_UTR$ 17 74 PAPROPQUOTEAMT PA Propose Quote Amount Currency DLR17_RBS0_UTR$ 17 75 PAFINQUOTEAMT PA Final Quote Amount Currency DLR17_RBS0_UTR$ 17 76 PAQUOTEPREPBY PA Quote Prepared By String STR20_LB 20 77 PAQUOTEAPPRVBY PA Quote Approved By String STR20_LB 20 78 PAREVBUDGTAMT PA Revise Budget Amount Currency DLR17_RBS0_UTR$ 17 79 PAREVPROJAMT PA Revise Project Amount Currency DLR17_RBS0_UTR$ 17 80 PAsequencenumber PA Sequence Number 1 Integer INT5 4 81 APPRVLDT Approval Date Date DATE 6 82 PAClose_CB PA Close CB Boolean CB_Close 0 83 PAPostedQty PA Actual Qty Currency PA_DLR15_RBS0_STR 15 84 PAPostedTotalCostN PA Actual Total Cost Currency PA_DLR17_RBS0_STR$ 17 85 PAPosted_Overhead PA Actual Overhead Currency PA_DLR17_RBS0_STR$ 17 86 PAPostedProfitN PA Actual Profit Currency PA_DLR17_RBS0_STR$ 17 87 PAPosted_Tax_Amount PA Actual Tax Amount Currency PA_DLR17_RBS0_STR$ 17 88 PAPosted_Accr_RevN PA Actual Accrued Revenues Currency PA_DLR17_RBS0_STR$ 17 89 PAPostRecogRevN PA Actual Recognized Revenue Currency PA_DLR17_RBS0_STR$ 17 90 PAPOSBIEEAMOUNT PA Actual BIEE Amount Currency DLR17_RBS0_UTR$ 17 91 PAPOSEIEBAMOUNT PA Actual EIEB Amount Currency DLR17_RBS0_UTR$ 17 92 PApostbillamt PA Actual Billed Amount Currency DLR17_RBS0_UTR$ 17 93 PA_Actual_Receipts_Amoun PA Actual Receipts Amount Currency PA_DLR17_RBS0_STR$ 17 94 PAPostedBillingsN PA Actual Billings Currency PA_DLR17_RBS0_STR$ 17 95 PAPostedDiscDolAmtN PA Actual Discount Dollar Amount Currency PA_DLR17_RBS0_STR$ 17 96 PAPosted_Sales_Tax_Amou PA Actual Sales Tax Amount Currency PA_DLR17_RBS0_STR$ 17 97 ActualWriteOffAmount Actual Write Off Amount Currency DLR17_RBS0_UTR$ 17 98 ActualDiscTakenAmount Actual Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 99 PAPostedTaxPaidN PA Actual Tax Paid Currency PA_DLR17_RBS0_STR$ 17 100 PAPOSTRETAMT PA Actual Retention Amount Currency PA_DLR17_RBS0_STR$ 17 101 PAActualWOTaxAmt PA Actual Write Off Tax Amount Currency PA_DLR17_RBS0_STR$ 17 102 PAActualTermsTakenTax PA Actual Terms Taken Tax Amt Currency PA_DLR17_RBS0_STR$ 17