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