PA Change Order Detail HIST (PA33702)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Detail HIST (PA33702)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA33702

Product: Project Accounting (258)
Series:

Display Name: PA Change Order Detail HIST
Physical Name: PA33702
Technical Name: PA_Change_Order_DTL_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
2PACHGORDNO SearchPA Change Order NumberStringSTR17_LBAU17
3PACOTRKCHGBY SearchPA CO Track Changes ByIntegerPA_DDL_CO_Track_Changes0
4LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
5PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
6PATU SearchPA Transaction UsageIntegerPA_DDL_Transaction_Usage0
7PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
8PALineItemSeq SearchPA Line Item SequenceLong IntegerLI_Sequence_Number10
9PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
10UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Change Order Detail HIST'].UOMSCHDL AS 'PA Change Order Detail HIST-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA33702 AS ['PA Change Order Detail HIST']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Change Order Detail HIST'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
11PAPREVBEGINDT SearchPA Prev Begin DateDatePA_Date8
12PAbegindate SearchPA Begin DateDatePA_Date8
13PAPREVENDDT SearchPA Prev End DateDatePA_Date8
14PAEnDate SearchPA End DateDateDT8
15PAPREVPYCDESLY SearchPA Prev Pay Code SalaryStringSTR6_Payroll_Code6
16PAPay_Code_Salary SearchPA Pay Code SalaryStringSTR6_Payroll_Code6
17PAPREVPYCODEHOURLY SearchPA Prev Pay Code HourlyStringSTR6_Payroll_Code6
18PAPay_Code_Hourly SearchPA Pay Code HourlyStringSTR6_Payroll_Code6
19PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
20PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
21PAPREVPURCHTXOPT SearchPA Prev Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
22PAPurchase_Tax_Options SearchPA Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
23PAPREVCOSTXSCHED SearchPA Prev Cost Tax Schedule IDStringSTR15_Tax_Schedule_ID15
24PAPURCHTAXSCHED SearchPA Purchase Tax Schedule IDStringSTR15_Tax_Schedule_ID15
25DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
26DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
27PAPREVSALESTXOPT SearchPA Prev Sales Tax OptionsIntegerPA_DDL_Tax_Options_Sales0
28PASales_Tax_Options SearchPA Sales Tax OptionsIntegerPA_DDL_Tax_Options_Sales0
29PAPREVBILLTXSCHED SearchPA Prev Billing Tax Schedule IDStringSTR15_Tax_Schedule_ID15
30PAbilltaxscheduleid SearchPA Billing Tax Schedule IDStringSTR15_Tax_Schedule_ID15
31PAVarianceQty SearchPA Variance QtyCurrencyDLR15_RBS215
32PAQtyQ SearchPA QuantityCurrencyPA_DLR15_RBS0_STR15
33PAVarianceCosts SearchPA Variance CostsCurrencyDLR17_RBSO_STR$17
34PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
35PAVARTOTCOST SearchPA Variance Total CostCurrencyDLR17_RBS0_STR$17
36PAVAROVERHDAMT SearchPA Variance Total Overhead AmountCurrencyDLR17_RBS0_STR$17
37PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
38PAVAROVERHDPRCNT SearchPA Variance Overhead PercentCurrencyDLR5_%28
39PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
40PAVAROVRHDUNIT SearchPA Variance Overhead Per UnitCurrencyDLR17_RBS0_STR$17
41PAOvhdAmtPerUnit SearchPA Overhead Amount Per UnitCurrencyDLR17_RBS0_UTR$17
42PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
43PAVARMUPRCNT SearchPA Variance Markup PercentageCurrencyDLR5_%28
44PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
45PAVARPROFAMT SearchPA Variance Profit AmountCurrencyDLR17_RBS0_STR$17
46PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
47PAVARTOTLPROF SearchPA Variance Total ProfitCurrencyDLR17_RBS0_STR$17
48PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
49PAVARTOTBILLINGS SearchPA Variance Total BillingsCurrencyDLR17_RBS0_STR$17
50PAtotbillings SearchPA Total BillingsCurrencyDLR17_RBS0_UTR$17
51PAORIGBUDGTAMT SearchPA Original Budget AmountCurrencyDLR17_RBS0_UTR$17
52PAROGPROJAMT SearchPA Original Project AmountCurrencyDLR17_RBS0_UTR$17
53PAVARPROJAMT SearchPA Variance Project AmountCurrencyDLR17_RBS0_STR$17
54PAProject_Amount SearchPA Project AmountCurrencyDLR17_RBS0_UTR$17
55PAPREVPROJAMT SearchPA Prev Project AmountCurrencyDLR17_RBS0_UTR$17
56PAPREVBASEQTY SearchPA Prev Base QtyCurrencyPA_DLR15_RBS0_STR15
57PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
58PAPREVBSEUNTCST SearchPA Prev Base Unit CostCurrencyDLR17_RBS0_UTR$17
59PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
60PAPREVBSOVERHDCST SearchPA Prev Base Overhead CostCurrencyDLR17_RBS0_UTR$17
61PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
62PAPREVBSPROFAMT SearchPA Prev Base Profit AmountCurrencyDLR17_RBS0_UTR$17
63PABaseProfitAmount SearchPA Base Profit AmountCurrencyDLR17_RBS0_UTR$17
64PAPROPQUOTEAMT SearchPA Propose Quote AmountCurrencyDLR17_RBS0_UTR$17
65PAFINQUOTEAMT SearchPA Final Quote AmountCurrencyDLR17_RBS0_UTR$17
66PAQUOTEPREPBY SearchPA Quote Prepared ByStringSTR20_LB20
67PAQUOTEAPPRVBY SearchPA Quote Approved ByStringSTR20_LB20
68PAREVBUDGTAMT SearchPA Revise Budget AmountCurrencyDLR17_RBS0_UTR$17
69PAREVPROJAMT SearchPA Revise Project AmountCurrencyDLR17_RBS0_UTR$17
70PAsequencenumber SearchPA Sequence Number 1IntegerINT54
71APPRVLDT SearchApproval DateDateDATE6
72PAClose_CB SearchPA Close CBBooleanCB_Close0
73PAPostedQty SearchPA Actual QtyCurrencyPA_DLR15_RBS0_STR15
74PAPostedTotalCostN SearchPA Actual Total CostCurrencyPA_DLR17_RBS0_STR$17
75PAPosted_Overhead SearchPA Actual OverheadCurrencyPA_DLR17_RBS0_STR$17
76PAPostedProfitN SearchPA Actual ProfitCurrencyPA_DLR17_RBS0_STR$17
77PAPosted_Tax_Amount SearchPA Actual Tax AmountCurrencyPA_DLR17_RBS0_STR$17
78PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
79PAPostRecogRevN SearchPA Actual Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
80PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountCurrencyDLR17_RBS0_UTR$17
81PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountCurrencyDLR17_RBS0_UTR$17
82PApostbillamt SearchPA Actual Billed AmountCurrencyDLR17_RBS0_UTR$17
83PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountCurrencyPA_DLR17_RBS0_STR$17
84PAPostedBillingsN SearchPA Actual BillingsCurrencyPA_DLR17_RBS0_STR$17
85PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountCurrencyPA_DLR17_RBS0_STR$17
86PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountCurrencyPA_DLR17_RBS0_STR$17
87ActualWriteOffAmount SearchActual Write Off AmountCurrencyDLR17_RBS0_UTR$17
88ActualDiscTakenAmount SearchActual Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
89PAPostedTaxPaidN SearchPA Actual Tax PaidCurrencyPA_DLR17_RBS0_STR$17
90PAPOSTRETAMT SearchPA Actual Retention AmountCurrencyPA_DLR17_RBS0_STR$17
91PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountCurrencyPA_DLR17_RBS0_STR$17
92PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtCurrencyPA_DLR17_RBS0_STR$17
azurecurveProductsProject Accounting (258)ProjectPA Change Order Detail HIST (PA33702)

Leave a Reply

Your email address will not be published. Required fields are marked *