Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA00901
Product: Project Accounting (258)
Series:
Display Name: PA Vendor MSTR
Physical Name: PA00901
Technical Name: PA_Vendor_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PA Vendor MSTR'].VENDORID AS 'PA Vendor MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PA00901 AS ['PA Vendor MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA Vendor MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
2 | PAfromemployee | PA From Employee | Boolean | Boolean | 0 | |
3 | PAddlDefpoformatouse | PA DDL Default PO Format to Use | Integer | DDL | 0 | |
4 | PAUnit_of_Measure | PA Unit of Measure | String | U_Of_M | 8 | |
5 | PAUNITCOST | PA Unit Cost | Currency | PA_DLR17_RBS0_UTR$ | 17 | |
6 | PATMProfitType | PA Profit Type - TM | Integer | PA_DDL_Profit_Type | 0 | |
7 | PATMProfitAmount | PA Profit Amount - TM | Currency | DLR17_RBS0_UTR$ | 17 | |
8 | PATMProfitPercent | PA Profit Percent - TM | Currency | DLR5_%2 | 8 | |
9 | PAFFProfitType | PA Profit Type - FF | Integer | PA_DDL_Profit_Type | 0 | |
10 | PAProfit_Type__CP | PA Profit Type - CP | Integer | PA_DDL_Profit_Type | 0 | |
11 | PAProfitAmountCP | PA Profit Amount - CP | Currency | DLR17_RBS0_UTR$ | 17 | |
12 | PAProfitPercentCP | PA Profit Percent - CP | Currency | DLR5_%2 | 8 | |
13 | PAFFProfitAmount | PA Profit Amount - FF | Currency | DLR17_RBS0_UTR$ | 17 | |
14 | PAFFProfitPercent | PA Profit Percent - FF | Currency | DLR5_%2 | 8 | |
15 | PAUD1 | PA User Defined 1 | String | STR20 | 20 | |
16 | PAUD2 | PA User Defined 2 | String | STR20 | 20 | |
17 | PA_Allow_Vendor_For_PO | PA Allow Vendor For PO | Boolean | PA_CB_VendorAllow_PO | 0 |