Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA89422
Product: Project Accounting (258)
Series:
Display Name: PA Budget Template File Lookup
Physical Name: PA89422
Technical Name: PA_Budget_Template_LookupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PACTID 
PA Contract Template ID String STR15_Contract_Class_ID 15 2 PAPTID PA Project Template ID String STR15_Project_Class_ID 15 3 PATU PA Transaction Usage Integer PA_DDL_Transaction_Usage 0 4 PACOSTCATID PA Cost Category ID String STR15_Cost_Category_ID 15 5 PAIV_Item_Checkbox PA IV Item Checkbox Boolean PA_CB_IV_Item 0 6 PASTAT PA Status Integer PA_DDL_Status 0 7 PAProfitType PA Profit Type Integer PA_DDL_Profit_Type 0 8 PAbllngtype PA Billing Type Integer PA_DDL_Billing_Type 0 9 PABase_Qty PA Base Qty Currency PA_DLR15_RBS0_STR 15 10 PABase_Unit_Cost PA Base Unit Cost Currency PA_DLR17_RBS0_STR$ 17 11 PABaseProfitAmount PA Base Profit Amount Currency DLR17_RBS0_UTR$ 17 12 PABaseOvhdCost PA Base Overhead Cost Currency DLR17_RBS0_UTR$ 17 13 PAForecastBaseOvrhdAmt PA Forecast Base Overhead Amount Currency DLR17_RBS0_UTR$ 17 14 PABBeginDate PA Baseline Begin Date Date DATE 6 15 PABEndDate PA Baseline End Date Date DATE 6 16 PABQuantity PA Baseline Quantity Currency DLR15_RBU2 15 17 PABUnitCost PA Baseline Unit Cost Currency DLR17_RBS0_UTR$ 17 18 PABTotalCost PA Baseline Total Cost Currency DLR17_RBS0_UTR$ 17 19 PABBillings PA Baseline Billings Currency DLR17_RBS0_UTR$ 17 20 PABProfit PA Baseline Profit Currency DLR17_RBS0_STR$ 17 21 PABProfitAmt PA Baseline Profit Amount Currency DLR17_RBS0_UTR$ 17 22 PABProfitPcnt PA Baseline Profit Percent Currency DLR5_%2 8 23 PABTaxPaidAmt PA Baseline Tax Paid Amount Currency DLR17_RBS0_UTR$ 17 24 PABTaxChargedAmt PA Baseline Tax Charged Amount Currency DLR17_RBS0_UTR$ 17 25 PABaselineOvhdCost PA Baseline Overhead Cost Currency DLR17_RBS0_UTR$ 17 26 PAForecastBaseQty PA Forecast Base Qty Currency DLR15_RBU2 15 27 PAForecastBaseUnitCost PA Forecast Base Unit Cost Currency DLR17_RBS0_UTR$ 17 28 PAFBeginDate PA Forecast Begin Date Date DATE 6 29 PAFEndDate PA Forecast End Date Date DATE 6 30 PAFQuantity PA Forecast Quantity Currency DLR15_RBU2 15 31 PAFUnitCost PA Forecast Unit Cost Currency DLR17_RBS0_UTR$ 17 32 PAFTotalCost PA Forecast Total Cost Currency DLR17_RBS0_UTR$ 17 33 PAFBillings PA Forecast Billings Currency DLR17_RBS0_UTR$ 17 34 PAFProfit PA Forecast Profit Currency DLR17_RBS0_STR$ 17 35 PAFProfitAmt PA Forecast Profit Amount Currency DLR17_RBS0_UTR$ 17 36 PAFProfitPcnt PA Forecast Profit Percent Currency DLR5_%2 8 37 PAFTaxPaidAmt PA Forecast Tax Paid Amount Currency DLR17_RBS0_UTR$ 17 38 PAFTaxChargedAmt PA Forecast Tax Charged Amount Currency DLR17_RBS0_UTR$ 17 39 PAForecastOvhdCost PA Forecast Overhead Cost Currency DLR17_RBS0_UTR$ 17 40 PAUnit_of_Measure PA Unit of Measure String U_Of_M 8 41 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 Template File Lookup'].UOMSCHDL AS 'PA Budget Template File Lookup-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
PA89422 AS ['PA Budget Template File Lookup']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['PA Budget Template File Lookup'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL42 PAUOfMMult PA UOfM Multiplier Currency DLR17_QTY_RBS0_UTR 17 43 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 44 PAPay_Code_Hourly PA Pay Code Hourly String STR6_Payroll_Code 6 45 PAPay_Code_Salary PA Pay Code Salary String STR6_Payroll_Code 6 46 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 47 PALabor_Rate_Table_ID PA Labor Rate Table ID String STR30_Rate_Table_ID 30 48 PALabor_RateTable_Type PA Labor Rate Table Type Integer PA_DDL_Rate_Table_Type 0 49 PALabor_Rate_Table_Acc PA Labor Rate Table Accept Boolean CB_Rate_Table_Accept 0 50 PAEquip_Rate_Table_ID PA Equip Rate Table ID String STR30_Rate_Table_ID 30 51 PAEquip_Rate_Table_Acc PA Equip Rate Table Accept Boolean CB_Rate_Table_Accept 0 52 TM_WIP_SRC TM WIP SRC Integer DDL_AccountSource 0 53 TM_COGS_SRC TM COGS SRC Integer DDL_AccountSource 0 54 TM_Cost_Contra_SRC TM Cost Contra SRC Integer DDL_AccountSource 0 55 TM_Unbilled_AR_SRC TM Unbilled AR SRC Integer DDL_AccountSource 0 56 TM_Unbilled_Rev_SRC TM Unbilled Rev SRC Integer DDL_AccountSource 0 57 TM_AR_SRC TM AR SRC Integer DDL_AccountSource 0 58 TM_Prj_Rev_SRC TM Prj Rev SRC Integer DDL_AccountSource 0 59 TM_OVHD_SRC TM OVHD SRC Integer DDL_AccountSource 0 60 FF_WIP_SRC FF WIP SRC Integer DDL_AccountSource 0 61 FF_Cost_Contra_SRC FF Cost Contra SRC Integer DDL_AccountSource 0 62 FF_AR_SRC FF AR SRC Integer DDL_AccountSource 0 63 FF_Prj_Billings_SRC FF Prj Billings SRC Integer DDL_AccountSource 0 64 FF_Prj_Expense_SRC FF Prj Expense SRC Integer DDL_AccountSource 0 65 FF_Prj_Revenue_SRC FF Prj Revenue SRC Integer DDL_AccountSource 0 66 FF_Prj_Loss_SRC FF Prj Loss SRC Integer DDL_AccountSource 0 67 FF_BIEE_SRC FF BIEE SRC Integer DDL_AccountSource 0 68 FF_EIEB_SRC FF EIEB SRC Integer DDL_AccountSource 0 69 FF_OVHD_SRC FF OVHD SRC Integer DDL_AccountSource 0 70 PAcostaxscheduleid PA Cost Tax Schedule ID String STR15_Tax_Schedule_ID 15 71 PAPurchase_Tax_Options PA Purchase Tax Options Integer PA_DDL_Tax_Options_Purchase 0 72 PAbilltaxscheduleid PA Billing Tax Schedule ID String STR15_Tax_Schedule_ID 15 73 PASales_Tax_Options PA Sales Tax Options Integer PA_DDL_Tax_Options_Sales 0 74 PAProject_Amount PA Project Amount Currency DLR17_RBS0_UTR$ 17 75 PAOverheadRateMethod PA Overhead Rate Method Integer GB 0 76 PABaselineOvhdAmtPerUnit PA Baseline Overhead Amount Per Unit Currency DLR17_RBS0_UTR$ 17 77 PABaselineOvrhdPct PA Baseline Overhead Percentage Currency DLR5_%2 8 78 PAForecastOvrhdAmtPerUnt PA Forecast Overhead Amount Per Unit Currency DLR17_RBS0_UTR$ 17 79 PAForecastOvrhdPct PA Forecast Overhead Percentage Currency DLR5_%2 8 80 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 81 PALineItemSeq PA Line Item Sequence Long Integer LI_Sequence_Number 10 82 PAbillnoteidx PA Billing Note Index Currency DLR14 14