PA Cost Category Class Setup File (PA41001)

azurecurveProductsProject Accounting (258)ProjectPA Cost Category Class Setup File (PA41001)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Cost Category Class Setup File
Physical Name: PA41001
Technical Name: PA_Cost_Category_Class_SETP

Group Display Name: PA Budgeting Class
Group Technical Name: PA Budgeting Class

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PACOSTCATCLASID SearchPA Cost Category Class IDSTR15_Cost_Category_Class_IDString15
2PACOSTCATCLASNME SearchPA Cost Category Class NameSTR30_PTBS Description 1String30
3PADC SearchPA Default ClassCB_DefaultBoolean0
4PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
5PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean0
6PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString8
7UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Cost Category Class Setup File'].UOMSCHDL AS 'PA Cost Category Class Setup File-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA41001 AS ['PA Cost Category Class Setup File']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Cost Category Class Setup File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
8DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
9PAUNITCOST SearchPA Unit CostPA_DLR17_RBS0_UTR$Currency17
10PAPay_Code_Hourly SearchPA Pay Code HourlySTR6_Payroll_CodeString6
11PAPay_Code_Salary SearchPA Pay Code SalarySTR6_Payroll_CodeString6
12PATMProfitType SearchPA Profit Type - TMPA_DDL_Profit_TypeInteger0
13PATMProfitAmount SearchPA Profit Amount - TMDLR17_RBS0_UTR$Currency17
14PATMProfitPercent SearchPA Profit Percent - TMDLR5_%2Currency8
15PAProfit_Type__CP SearchPA Profit Type - CPPA_DDL_Profit_TypeInteger0
16PAProfitAmountCP SearchPA Profit Amount - CPDLR17_RBS0_UTR$Currency17
17PAProfitPercentCP SearchPA Profit Percent - CPDLR5_%2Currency8
18PAFFProfitType SearchPA Profit Type - FFPA_DDL_Profit_TypeInteger0
19PAFFProfitAmount SearchPA Profit Amount - FFDLR17_RBS0_UTR$Currency17
20PAFFProfitPercent SearchPA Profit Percent - FFDLR5_%2Currency8
21DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
22PAcostaxscheduleid SearchPA Cost Tax Schedule IDSTR15_Tax_Schedule_IDString15
23PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
24PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
25PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
26PAOverheadRateMethod SearchPA Overhead Rate MethodGBInteger0
27PAOvhdAmtPerUnit SearchPA Overhead Amount Per UnitDLR17_RBS0_UTR$Currency17
28PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency8
29PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
30PANOTEINDEX SearchPA Note IndexDLR14Currency14
31DEX_ROW_ID Searchintint10

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.

azurecurveProductsProject Accounting (258)ProjectPA Cost Category Class Setup File (PA41001)

Leave a Reply

Your email address will not be published. Required fields are marked *