Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA40901
Product: Project Accounting (258)
Series:
Display Name: PA Vendor Class Setup
Physical Name: PA40901
Technical Name: PA_Vendor_Class_SETP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | VNDCLSID | Vendor Class ID | String | STR10_Class_ID | 10 | |
Key to the PM Class Master File (PM00100).
Click to show/hideSELECT
['PA Vendor Class Setup'].VNDCLSID AS 'PA Vendor Class Setup-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
PA40901 AS ['PA Vendor Class Setup']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['PA Vendor Class Setup'].VNDCLSID = ['PM Class Master File'].VNDCLSID | ||||||
2 | PAddlDefpoformatouse | PA DDL Default PO Format to Use | Integer | DDL | 0 | |
3 | PAUnit_of_Measure | PA Unit of Measure | String | U_Of_M | 8 | |
4 | PAUNITCOST | PA Unit Cost | Currency | PA_DLR17_RBS0_UTR$ | 17 | |
5 | PATMProfitType | PA Profit Type - TM | Integer | PA_DDL_Profit_Type | 0 | |
6 | PATMProfitAmount | PA Profit Amount - TM | Currency | DLR17_RBS0_UTR$ | 17 | |
7 | PATMProfitPercent | PA Profit Percent - TM | Currency | DLR5_%2 | 8 | |
8 | PAProfit_Type__CP | PA Profit Type - CP | Integer | PA_DDL_Profit_Type | 0 | |
9 | PAProfitAmountCP | PA Profit Amount - CP | Currency | DLR17_RBS0_UTR$ | 17 | |
10 | PAProfitPercentCP | PA Profit Percent - CP | Currency | DLR5_%2 | 8 | |
11 | PAFFProfitType | PA Profit Type - FF | Integer | PA_DDL_Profit_Type | 0 | |
12 | PAFFProfitAmount | PA Profit Amount - FF | Currency | DLR17_RBS0_UTR$ | 17 | |
13 | PAFFProfitPercent | PA Profit Percent - FF | Currency | DLR5_%2 | 8 |