PA00901 - PA Vendor MSTR
Dynamics GP table PA00901 (PA Vendor MSTR) contains 17 columns including VENDORID, PAfromemployee, PAddlDefpoformatouse....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| VENDORID | Vendor ID | String | 16 | |
| PAfromemployee | PA From Employee | Boolean | 2 | |
| PAddlDefpoformatouse | PA DDL Default PO Format to Use | Integer | 2 | |
| PAUnit_of_Measure | PA Unit of Measure | String | 10 | |
| PAUNITCOST | PA Unit Cost | Currency | 10 | |
| PATMProfitType | PA Profit Type - TM1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level | Integer | 2 | |
| PATMProfitAmount | PA Profit Amount - TM | Currency | 10 | |
| PATMProfitPercent | PA Profit Percent - TM | Currency | 10 | |
| PAFFProfitType | PA Profit Type - FF1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level | Integer | 2 | |
| PAProfit_Type__CP | PA Profit Type - CP1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level | Integer | 2 | |
| PAProfitAmountCP | PA Profit Amount - CP | Currency | 10 | |
| PAProfitPercentCP | PA Profit Percent - CP | Currency | 10 | |
| PAFFProfitAmount | PA Profit Amount - FF | Currency | 10 | |
| PAFFProfitPercent | PA Profit Percent - FF | Currency | 10 | |
| PAUD1 | PA User Defined 1 | String | 22 | |
| PAUD2 | PA User Defined 2 | String | 22 | |
| PA_Allow_Vendor_For_PO | PA Allow Vendor For PO | Boolean | 2 |
Related Tables
Tables that share columns with PA00901. Click "Join" to add to your query.