PA Budget IVItems (PA01303)

azurecurve Products Project Accounting (258)ProjectPA Budget IVItems (PA01303)

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

Product: Project Accounting (258)
Series:

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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PAPROJNUMBER	PA Project Number	String	STR15_LBAU	15
2	PACOSTCATID	PA Cost Category ID	String	STR15_Cost_Category_ID	15
3	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	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
4	PABase_Qty	PA Base Qty	Currency	PA_DLR15_RBS0_STR	15
5	PABase_Unit_Cost	PA Base Unit Cost	Currency	PA_DLR17_RBS0_STR$	17
6	PABaseProfitAmount	PA Base Profit Amount	Currency	DLR17_RBS0_UTR$	17
7	PABaseOvhdCost	PA Base Overhead Cost	Currency	DLR17_RBS0_UTR$	17
8	PABQuantity	PA Baseline Quantity	Currency	DLR15_RBU2	15
9	PAForecastBaseQty	PA Forecast Base Qty	Currency	DLR15_RBU2	15
10	PAForecastBaseUnitCost	PA Forecast Base Unit Cost	Currency	DLR17_RBS0_UTR$	17
11	PAForecastBaseProfitAmt	PA Forecast Base Profit Amount	Currency	DLR17_RBS0_UTR$	17
12	PABUnitCost	PA Baseline Unit Cost	Currency	DLR17_RBS0_UTR$	17
13	PABTotalCost	PA Baseline Total Cost	Currency	DLR17_RBS0_UTR$	17
14	PABBillings	PA Baseline Billings	Currency	DLR17_RBS0_UTR$	17
15	PABProfitAmt	PA Baseline Profit Amount	Currency	DLR17_RBS0_UTR$	17
16	PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	DLR17_RBS0_UTR$	17
17	PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
18	PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
19	PABaselinePTaxOptions	PA Baseline Purchase Tax Options	Integer	PA_DDL_Tax_Options_Purchase	0
20	PABaselineCTaxSchedID	PA Baseline Cost Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
21	PABaselineSTaxOptions	PA Baseline Sales Tax Options	Integer	PA_DDL_Tax_Options_Sales	0
22	PABaselineBTaxSchedID	PA Baseline Billing Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
23	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
24	PAFUnitCost	PA Forecast Unit Cost	Currency	DLR17_RBS0_UTR$	17
25	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
26	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
27	PAFProfitAmt	PA Forecast Profit Amount	Currency	DLR17_RBS0_UTR$	17
28	PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	DLR17_RBS0_UTR$	17
29	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
30	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
31	PAForecastPTaxOptions	PA Forecast Purchase Tax Options	Integer	PA_DDL_Tax_Options_Purchase	0
32	PAForecastCTaxSchedID	PA Forecast Cost Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
33	PAForecastSTaxOptions	PA Forecast Sales Tax Options	Integer	PA_DDL_Tax_Options_Sales	0
34	PAForecastBTaxSchedID	PA Forecast Billing Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
35	UOFM	U Of M	String	U_Of_M	8
36	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 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
37	PRICELVL	Price Level	String	STR15_LBAU	15
38	PAUOfMMult	PA UOfM Multiplier	Currency	DLR17_QTY_RBS0_UTR	17
39	PAbllngtype	PA Billing Type	Integer	PA_DDL_Billing_Type	0
40	PAbillnoteidx	PA Billing Note Index	Currency	DLR14	14
41	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
42	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
43	PAPostedQty	PA Actual Qty	Currency	PA_DLR15_RBS0_STR	15
44	PApstdcosts	PA Actual Costs	Currency	DLR17_RBS0_UTR$	17
45	PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
46	PAPosted_Return_QTY	PA Actual Return QTY	Currency	DLR15_RBU2	15
47	PAPosted_Return_Costs	PA Actual Return Costs	Currency	DLR17_RBS0_UTR$	17
48	PAActualReturnAccrRev	PA Actual Return Accrued Revenue	Currency	DLR17_RBS0_UTR$	17
49	PAunpcosts	PA Unposted Costs	Currency	DLR17_RBS0_UTR$	17
50	PAUnpQty	PA Unposted QTY	Currency	DLR15_RBU2	15
51	PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
52	PAUnposted_Return_QTY	PA Unposted Return QTY	Currency	DLR15_RBU2	15
53	PAUnposted_Return_Cost	PA Unposted Return Costs	Currency	DLR17_RBS0_UTR$	17
54	PAUnpostedReturnAccrRev	PA Unposted Return Accrued Revenue	Currency	DLR17_RBS0_UTR$	17
55	PAPOCost	PA PO Cost	Currency	DLR17_RBS0_UTR$	17
56	PAPOQty	PA PO Qty	Currency	DLR15_RBU2	15
57	PACommitted_Costs	PA Committed Costs	Currency	DLR17_RBS0_UTR$	17
58	PACommitted_Qty	PA Committed Qty	Currency	DLR15_RBU2	15
59	PAPOPostedQty	PA PO Actual Qty	Currency	PA_DLR15_RBS0_STR	15
60	PAPOPostedCost	PA PO Actual Cost	Currency	DLR17_RBS0_UTR$	17
61	REQDATE	Required Date	Date	DATE_L	0
62	PALineItemSeq	PA Line Item Sequence	Long Integer	LI_Sequence_Number	10
63	PAPostedBillingsN	PA Actual Billings	Currency	PA_DLR17_RBS0_STR$	17
64	PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
65	PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
66	PACHGORDNO	PA Change Order Number	String	STR17_LBAU	17

azurecurve Products Project Accounting (258)ProjectPA Budget IVItems (PA01303)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply