PA Budget Periodic Totals Master File (PA01304)

azurecurve Products Project Accounting (258)ProjectPA Budget Periodic Totals Master File (PA01304)

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

Product: Project Accounting (258)
Series:

Display Name: PA Budget Periodic Totals Master File
Physical Name: PA01304
Technical Name: PA_Budget_Periodic_Totals_MSTR

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	PATU	PA Transaction Usage	Integer	PA_DDL_Transaction_Usage	0
3	PAsfid	PA Source File ID	Integer	INT3	3
4	PACOSTCATID	PA Cost Category ID	String	STR15_Cost_Category_ID	15
5	PERIODID	Period ID	Integer	INT3	3
6	YEAR1	Year	Integer	Year	4
7	PAPeriodStartDate	PA Period Start Date	Date	DATE	6
8	PAPeriodEndDate	PA Period End Date	Date	DATE	6
9	PERIODDT	Period Date	Date	DT_Date	6
10	PAACTUALBEGDATE	PA Actual Begin Date	Date	DATE	6
11	PA_Actual_End_Date	PA Actual End Date	Date	DATE	6
12	PABQuantity	PA Baseline Quantity	Currency	DLR15_RBU2	15
13	PAFeeAmount	PA Fee Amount	Currency	DLR17_RBSO_STR$	17
14	PABUnitCost	PA Baseline Unit Cost	Currency	DLR17_RBS0_UTR$	17
15	PABTotalCost	PA Baseline Total Cost	Currency	DLR17_RBS0_UTR$	17
16	PABProfit	PA Baseline Profit	Currency	DLR17_RBS0_STR$	17
17	PABProfitAmt	PA Baseline Profit Amount	Currency	DLR17_RBS0_UTR$	17
18	PABBillings	PA Baseline Billings	Currency	DLR17_RBS0_UTR$	17
19	PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
20	PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
21	PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	DLR17_RBS0_UTR$	17
22	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
23	PAFUnitCost	PA Forecast Unit Cost	Currency	DLR17_RBS0_UTR$	17
24	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
25	PAFProfit	PA Forecast Profit	Currency	DLR17_RBS0_STR$	17
26	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
27	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
28	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
29	PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	DLR17_RBS0_UTR$	17
30	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
31	PAUnpostedQty	PA Unposted Qty	Currency	PA_DLR15_RBS0_STR	15
32	PAUnpostedTotalCostN	PA Unposted Total Cost	Currency	PA_DLR17_RBS0_STR$	17
33	PAUnposted_Overhead	PA Unposted Overhead	Currency	PA_DLR17_RBS0_STR$	17
34	PAUnpostedProfitN	PA Unposted Profit	Currency	PA_DLR17_RBS0_STR$	17
35	PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
36	PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
37	PAUnpostedCommitedQty	PA Unposted Commited Qty	Currency	DLR15_RBU2	15
38	PAUnpostedCommitedCost	PA Unposted Commited Cost	Currency	DLR17_RBS0_UTR$	17
39	PAUnpostedCommitedTaxAmt	PA Unposted Commited Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
40	PAUnpostedRecogRevN	PA Unposted Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
41	PAUnposted_Fee_Amount	PA Unposted Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
42	PAUNPOSTBIEEAMOUNT	PA Unposted BIEE Amount	Currency	DLR17_RBS0_UTR$	17
43	PAUNPEIEBAMOUNT	PA Unposted EIEB Amount	Currency	DLR17_RBS0_UTR$	17
44	PA_Unposted_Billed_Reten	PA Unposted Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
45	PAunpostbillamt	PA Unposted Billed Amount	Currency	DLR17_RBS0_UTR$	17
46	PAPostedQty	PA Actual Qty	Currency	PA_DLR15_RBS0_STR	15
47	PAPostedTotalCostN	PA Actual Total Cost	Currency	PA_DLR17_RBS0_STR$	17
48	PAPosted_Overhead	PA Actual Overhead	Currency	PA_DLR17_RBS0_STR$	17
49	PAPostedProfitN	PA Actual Profit	Currency	PA_DLR17_RBS0_STR$	17
50	PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
51	PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
52	PAPostedCommitedQty	PA Actual Commited Qty	Currency	DLR15_RBU2	15
53	PAPostRecogRevN	PA Actual Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
54	PAPostedCommitedCost	PA Actual Commited Cost	Currency	DLR17_RBS0_UTR$	17
55	PAPostedCommitedTaxAmt	PA Actual Commited Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
56	PAPosted_Fee_Amount	PA Actual Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
57	PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	DLR17_RBS0_UTR$	17
58	PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	DLR17_RBS0_UTR$	17
59	PA_Actual_Billed_Retenti	PA Actual Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
60	PApostbillamt	PA Actual Billed Amount	Currency	DLR17_RBS0_UTR$	17
61	PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	PA_DLR17_RBS0_STR$	17
62	PAApproved_Quantity	PA Approved Quantity	Currency	PA_DLR15_RBS0_STR	15
63	PARemaining_Quantity	PA Remaining Quantity	Currency	PA_DLR15_RBS0_STR	15
64	PABilled_QtyN	PA Billed Qty	Currency	PA_DLR15_RBS0_STR	15
65	PAApproved_Cost	PA Approved Cost	Currency	PA_DLR17_RBS0_STR$	17
66	PARemaining_Cost	PA Remaining Cost	Currency	PA_DLR17_RBS0_STR$	17
67	PABilled_Cost	PA Billed Cost	Currency	PA_DLR17_RBS0_STR$	17
68	PAApproved_Accrued_Reve	PA Approved Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
69	PARemaining_Accrued_Rev	PA Remaining Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
70	PABilled_Accrued_Revenu	PA Billed Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
71	PACostPcntCompleted	PA Cost Percent Completed	Currency	DLR5_%2	8
72	PAQuantityPcntCompleted	PA Quantity Percent Completed	Currency	DLR5_%2	8
73	PA_Receipts_Amount	PA Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
74	PA_Actual_Receipts_Amoun	PA Actual Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
75	PA_Earnings	PA Earnings	Currency	PA_DLR17_RBS0_STR$	17
76	PA_Cost_of_Earnings	PA Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
77	PAUnpostBillN	PA Unposted Billings	Currency	PA_DLR17_RBS0_STR$	17
78	PAUnpostDiscDolAmtN	PA Unposted Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
79	PAUnposted_Sales_Tax_Am	PA Unposted Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
80	PAPostedBillingsN	PA Actual Billings	Currency	PA_DLR17_RBS0_STR$	17
81	PAPostedDiscDolAmtN	PA Actual Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
82	PAPosted_Sales_Tax_Amou	PA Actual Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
83	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
84	ActualWriteOffAmount	Actual Write Off Amount	Currency	DLR17_RBS0_UTR$	17
85	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
86	ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
87	PACommitted_Costs	PA Committed Costs	Currency	DLR17_RBS0_UTR$	17
88	PACommitted_Qty	PA Committed Qty	Currency	DLR15_RBU2	15
89	PAPOCost	PA PO Cost	Currency	DLR17_RBS0_UTR$	17
90	PAPOQty	PA PO Qty	Currency	DLR15_RBU2	15
91	PAPOPostedCost	PA PO Actual Cost	Currency	DLR17_RBS0_UTR$	17
92	PAPOPostedQty	PA PO Actual Qty	Currency	PA_DLR15_RBS0_STR	15
93	PAtaxpaidamt	PA Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
94	PAPostedTaxPaidN	PA Actual Tax Paid	Currency	PA_DLR17_RBS0_STR$	17
95	PAPOSTRETAMT	PA Actual Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
96	PAUNPOSTRETAMT	PA Unposted Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
97	PA_Write_Off_Tax_Amount	PA Write Off Tax Amount	Currency	DLR17_RBS0_STR$	17
98	PAActualWOTaxAmt	PA Actual Write Off Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
99	PA_Terms_Taken_Tax_Amt	PA Terms Taken Tax Amt	Currency	DLR17_RBS0_STR$	17
100	PAActualTermsTakenTax	PA Actual Terms Taken Tax Amt	Currency	PA_DLR17_RBS0_STR$	17
101	PAPosted_Earnings	PA Actual Earnings	Currency	PA_DLR17_RBS0_STR$	17
102	PAActualCostofEarnings	PA Actual Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
103	PAUnpostedLossAmount	PA Unposted Loss Amount	Currency	DLR17_RBS0_UTR$	17
104	PAActualLossAmount	PA Actual Loss Amount	Currency	DLR17_RBS0_UTR$	17

azurecurve Products Project Accounting (258)ProjectPA Budget Periodic Totals Master File (PA01304)

Leave a Reply Cancel reply