PA Budget IVItems (PA01303)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Budget IVItems
Physical Name: PA01303
Technical Name: PA_Budget_IVItems

Group Display Name: PA Budgeting Cards
Group Technical Name: PA Budgeting Cards

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
2PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['PA Budget IVItems'].ITEMNMBR AS 'PA Budget IVItems-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PA01303 AS ['PA Budget IVItems']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PA Budget IVItems'].ITEMNMBR = ['Item Master'].ITEMNMBR
4PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency15
5PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency17
6PABaseProfitAmount SearchPA Base Profit AmountDLR17_RBS0_UTR$Currency17
7PABaseOvhdCost SearchPA Base Overhead CostDLR17_RBS0_UTR$Currency17
8PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
9PAForecastBaseQty SearchPA Forecast Base QtyDLR15_RBU2Currency15
10PAForecastBaseUnitCost SearchPA Forecast Base Unit CostDLR17_RBS0_UTR$Currency17
11PAForecastBaseProfitAmt SearchPA Forecast Base Profit AmountDLR17_RBS0_UTR$Currency17
12PABUnitCost SearchPA Baseline Unit CostDLR17_RBS0_UTR$Currency17
13PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
14PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency17
15PABProfitAmt SearchPA Baseline Profit AmountDLR17_RBS0_UTR$Currency17
16PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency17
17PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency17
18PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency17
19PABaselinePTaxOptions SearchPA Baseline Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
20PABaselineCTaxSchedID SearchPA Baseline Cost Tax Schedule IDSTR15_Tax_Schedule_IDString15
21PABaselineSTaxOptions SearchPA Baseline Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
22PABaselineBTaxSchedID SearchPA Baseline Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
23PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
24PAFUnitCost SearchPA Forecast Unit CostDLR17_RBS0_UTR$Currency17
25PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
26PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
27PAFProfitAmt SearchPA Forecast Profit AmountDLR17_RBS0_UTR$Currency17
28PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
29PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
30PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
31PAForecastPTaxOptions SearchPA Forecast Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
32PAForecastCTaxSchedID SearchPA Forecast Cost Tax Schedule IDSTR15_Tax_Schedule_IDString15
33PAForecastSTaxOptions SearchPA Forecast Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
34PAForecastBTaxSchedID SearchPA Forecast Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
35UOFM SearchU Of MU_Of_MString8
36UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Budget IVItems'].UOMSCHDL AS 'PA Budget IVItems-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA01303 AS ['PA Budget IVItems']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Budget IVItems'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
37PRICELVL SearchPrice LevelSTR15_LBAUString15
38PAUOfMMult SearchPA UOfM MultiplierDLR17_QTY_RBS0_UTRCurrency17
39PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger0
40PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
41DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
42DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
43PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
44PApstdcosts SearchPA Actual CostsDLR17_RBS0_UTR$Currency17
45PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
46PAPosted_Return_QTY SearchPA Actual Return QTYDLR15_RBU2Currency15
47PAPosted_Return_Costs SearchPA Actual Return CostsDLR17_RBS0_UTR$Currency17
48PAActualReturnAccrRev SearchPA Actual Return Accrued RevenueDLR17_RBS0_UTR$Currency17
49PAunpcosts SearchPA Unposted CostsDLR17_RBS0_UTR$Currency17
50PAUnpQty SearchPA Unposted QTYDLR15_RBU2Currency15
51PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
52PAUnposted_Return_QTY SearchPA Unposted Return QTYDLR15_RBU2Currency15
53PAUnposted_Return_Cost SearchPA Unposted Return CostsDLR17_RBS0_UTR$Currency17
54PAUnpostedReturnAccrRev SearchPA Unposted Return Accrued RevenueDLR17_RBS0_UTR$Currency17
55PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency17
56PAPOQty SearchPA PO QtyDLR15_RBU2Currency15
57PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency17
58PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency15
59PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency15
60PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency17
61REQDATE SearchRequired DateDATE_LDate0
62PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
63PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
64PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency17
65PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency17
66PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
67DEX_ROW_ID Searchintint10

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.

Leave a Reply

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