PM00203 - Vendor Accounts
Dynamics GP table PM00203 (Vendor Accounts) contains 5 columns including VENDORID, DISTTYPE, SEQNUMBR....
SQL Query Builder
5 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| VENDORID | Vendor ID | String | 16 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | ||
| Default_On_Trx | Default On Trx | Boolean | 2 | ||
Related Tables
Tables that share columns with PM00203. Click "Join" to add to your query.
Default_On_Trx