GP Tables

PA01304 - PA Budget Periodic Totals Master File

Dynamics GP table PA01304 (PA Budget Periodic Totals Master File) contains 104 columns including PAPROJNUMBER, PATU, PAsfid....

SQL Query Builder

104 Columns

Column Description Type Length
PAPROJNUMBER PA Project Number String 16
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PAsfid PA Source File ID Integer 2
PACOSTCATID PA Cost Category ID String 16
PERIODID Period ID Integer 2
YEAR1 Year Integer 2
PAPeriodStartDate PA Period Start Date Date 4
PAPeriodEndDate PA Period End Date Date 4
PERIODDT Period Date Date 4
PAACTUALBEGDATE PA Actual Begin Date Date 4
PA_Actual_End_Date PA Actual End Date Date 4
PABQuantity PA Baseline Quantity Currency 10
PAFeeAmount PA Fee Amount Currency 10
PABUnitCost PA Baseline Unit Cost Currency 10
PABTotalCost PA Baseline Total Cost Currency 10
PABProfit PA Baseline Profit Currency 10
PABProfitAmt PA Baseline Profit Amount Currency 10
PABBillings PA Baseline Billings Currency 10
PABTaxPaidAmt PA Baseline Tax Paid Amount Currency 10
PABTaxChargedAmt PA Baseline Tax Charged Amount Currency 10
PABaselineOvhdCost PA Baseline Overhead Cost Currency 10
PAFQuantity PA Forecast Quantity Currency 10
PAFUnitCost PA Forecast Unit Cost Currency 10
PAFTotalCost PA Forecast Total Cost Currency 10
PAFProfit PA Forecast Profit Currency 10
PAFBillings PA Forecast Billings Currency 10
PAFTaxPaidAmt PA Forecast Tax Paid Amount Currency 10
PAFTaxChargedAmt PA Forecast Tax Charged Amount Currency 10
PAForecastOvhdCost PA Forecast Overhead Cost Currency 10
LNITMSEQ Line Item Sequence Long Integer 4
PAUnpostedQty PA Unposted Qty Currency 10
PAUnpostedTotalCostN PA Unposted Total Cost Currency 10
PAUnposted_Overhead PA Unposted Overhead Currency 10
PAUnpostedProfitN PA Unposted Profit Currency 10
PAUnposted_Tax_Amount PA Unposted Tax Amount Currency 10
PAUnpostAccrRevN PA Unposted Accrued Revenues Currency 10
PAUnpostedCommitedQty PA Unposted Commited Qty Currency 10
PAUnpostedCommitedCost PA Unposted Commited Cost Currency 10
PAUnpostedCommitedTaxAmt PA Unposted Commited Tax Amount Currency 10
PAUnpostedRecogRevN PA Unposted Recognized Revenue Currency 10
PAUnposted_Fee_Amount PA Unposted Fee Amount Currency 10
PAUNPOSTBIEEAMOUNT PA Unposted BIEE Amount Currency 10
PAUNPEIEBAMOUNT PA Unposted EIEB Amount Currency 10
PA_Unposted_Billed_Reten PA Unposted Billed Retention Currency 10
PAunpostbillamt PA Unposted Billed Amount Currency 10
PAPostedQty PA Actual Qty Currency 10
PAPostedTotalCostN PA Actual Total Cost Currency 10
PAPosted_Overhead PA Actual Overhead Currency 10
PAPostedProfitN PA Actual Profit Currency 10
PAPosted_Tax_Amount PA Actual Tax Amount Currency 10
PAPosted_Accr_RevN PA Actual Accrued Revenues Currency 10
PAPostedCommitedQty PA Actual Commited Qty Currency 10
PAPostRecogRevN PA Actual Recognized Revenue Currency 10
PAPostedCommitedCost PA Actual Commited Cost Currency 10
PAPostedCommitedTaxAmt PA Actual Commited Tax Amount Currency 10
PAPosted_Fee_Amount PA Actual Fee Amount Currency 10
PAPOSBIEEAMOUNT PA Actual BIEE Amount Currency 10
PAPOSEIEBAMOUNT PA Actual EIEB Amount Currency 10
PA_Actual_Billed_Retenti PA Actual Billed Retention Currency 10
PApostbillamt PA Actual Billed Amount Currency 10
PAWrite_UpDown_Amount PA Write Up/Down Amount Currency 10
PAApproved_Quantity PA Approved Quantity Currency 10
PARemaining_Quantity PA Remaining Quantity Currency 10
PABilled_QtyN PA Billed Qty Currency 10
PAApproved_Cost PA Approved Cost Currency 10
PARemaining_Cost PA Remaining Cost Currency 10
PABilled_Cost PA Billed Cost Currency 10
PAApproved_Accrued_Reve PA Approved Accrued Revenues Currency 10
PARemaining_Accrued_Rev PA Remaining Accrued Revenues Currency 10
PABilled_Accrued_Revenu PA Billed Accrued Revenues Currency 10
PACostPcntCompleted PA Cost Percent Completed Currency 10
PAQuantityPcntCompleted PA Quantity Percent Completed Currency 10
PA_Receipts_Amount PA Receipts Amount Currency 10
PA_Actual_Receipts_Amoun PA Actual Receipts Amount Currency 10
PA_Earnings PA Earnings Currency 10
PA_Cost_of_Earnings PA Cost of Earnings Currency 10
PAUnpostBillN PA Unposted Billings Currency 10
PAUnpostDiscDolAmtN PA Unposted Discount Dollar Amount Currency 10
PAUnposted_Sales_Tax_Am PA Unposted Sales Tax Amount Currency 10
PAPostedBillingsN PA Actual Billings Currency 10
PAPostedDiscDolAmtN PA Actual Discount Dollar Amount Currency 10
PAPosted_Sales_Tax_Amou PA Actual Sales Tax Amount Currency 10
WROFAMNT Write Off Amount Currency 10
ActualWriteOffAmount Actual Write Off Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
ActualDiscTakenAmount Actual Discount Taken Amount Currency 10
PACommitted_Costs PA Committed Costs Currency 10
PACommitted_Qty PA Committed Qty Currency 10
PAPOCost PA PO Cost Currency 10
PAPOQty PA PO Qty Currency 10
PAPOPostedCost PA PO Actual Cost Currency 10
PAPOPostedQty PA PO Actual Qty Currency 10
PAtaxpaidamt PA Tax Paid Amount Currency 10
PAPostedTaxPaidN PA Actual Tax Paid Currency 10
PAPOSTRETAMT PA Actual Retention Amount Currency 10
PAUNPOSTRETAMT PA Unposted Retention Amount Currency 10
PA_Write_Off_Tax_Amount PA Write Off Tax Amount Currency 10
PAActualWOTaxAmt PA Actual Write Off Tax Amount Currency 10
PA_Terms_Taken_Tax_Amt PA Terms Taken Tax Amt Currency 10
PAActualTermsTakenTax PA Actual Terms Taken Tax Amt Currency 10
PAPosted_Earnings PA Actual Earnings Currency 10
PAActualCostofEarnings PA Actual Cost of Earnings Currency 10
PAUnpostedLossAmount PA Unposted Loss Amount Currency 10
PAActualLossAmount PA Actual Loss Amount Currency 10

Related Tables

Tables that share columns with PA01304. Click "Join" to add to your query.

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01241 PA01251 PA01301

PACOSTCATID

PA01001 PA01301 PA01303 PA01341 PA01342 PA10001 PA10101 PA10201

WROFAMNT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA00402 PA00501 PA00511 PA01101

YEAR1

ASIEXP13 ASIEXP18 ASIEXP32 CPO10113 CPO10114 CPO40002 CPO40003 EDCVAT02

PATU

PA000002 PA01001 PA01301 PA01341 PA01342 PA10601 PA10702 PA11800

PAApproved_Quantity

PA00501 PA00511 PA01101 PA01121 PA01201 PA01221 PA01301 PA10001

PAWrite_UpDown_Amount

PA00501 PA00511 PA01101 PA01121 PA01201 PA01221 PA01301 PA10001

PERIODID

ASIEXP12 ASIEXP13 CPO10113 CPO10114 EDCVAT03 ENC10113 ENC10114 ENCAA10210V