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 TypeSQL DB LengthKeyable Length
1PACOSTCATCLASID SearchPA Cost Category Class IDSTR15_Cost_Category_Class_IDString1615
2PACOSTCATCLASNME SearchPA Cost Category Class NameSTR30_PTBS Description 1String3230
3PADC SearchPA Default ClassCB_DefaultBoolean20
4PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
5PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean20
6PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString108
7UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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_QTYSInteger20
9PAUNITCOST SearchPA Unit CostPA_DLR17_RBS0_UTR$Currency1017
10PAPay_Code_Hourly SearchPA Pay Code HourlySTR6_Payroll_CodeString86
11PAPay_Code_Salary SearchPA Pay Code SalarySTR6_Payroll_CodeString86
12PATMProfitType SearchPA Profit Type - TMPA_DDL_Profit_TypeInteger20
13PATMProfitAmount SearchPA Profit Amount - TMDLR17_RBS0_UTR$Currency1017
14PATMProfitPercent SearchPA Profit Percent - TMDLR5_%2Currency108
15PAProfit_Type__CP SearchPA Profit Type - CPPA_DDL_Profit_TypeInteger20
16PAProfitAmountCP SearchPA Profit Amount - CPDLR17_RBS0_UTR$Currency1017
17PAProfitPercentCP SearchPA Profit Percent - CPDLR5_%2Currency108
18PAFFProfitType SearchPA Profit Type - FFPA_DDL_Profit_TypeInteger20
19PAFFProfitAmount SearchPA Profit Amount - FFDLR17_RBS0_UTR$Currency1017
20PAFFProfitPercent SearchPA Profit Percent - FFDLR5_%2Currency108
21DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
22PAcostaxscheduleid SearchPA Cost Tax Schedule IDSTR15_Tax_Schedule_IDString1615
23PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
24PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
25PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
26PAOverheadRateMethod SearchPA Overhead Rate MethodGBInteger20
27PAOvhdAmtPerUnit SearchPA Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
28PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency108
29PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
30PANOTEINDEX SearchPA Note IndexDLR14Currency1014
31DEX_ROW_ID Searchintint1010

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 *