| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|
| 1 | VNDCLSID  | Vendor Class ID | String | STR10_Class_ID | 10 |
| 2 | VNDCLDSC | Vendor Class Description | String | STR30 | 30 |
| 3 | DEFLTCLS | Default Class | Boolean | CB_Default | 0 |
| 4 | MXIAFVND | Maximum Invoice Amount For Vendors | Integer | GB | 0 |
| 5 | MXINVAMT | Maximum Invoice Amount | Currency | DLR17_$U2 | 17 |
| 6 | WRITEOFF | Writeoff | Integer | GB | 0 |
| 7 | CREDTLMT | Credit Limit | Integer | GB | 0 |
| 8 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 |
| 9 | PTCSHACF | Post To Cash Account From | Integer | GB | 0 |
| 10 | MXWOFAMT | Maximum Write Off Amount | Currency | DLR17_$U2 | 17 |
| 11 | MINORDER | Minimum Order | Currency | DLR17_$U2 | 17 |
| 12 | CRLMTDLR | Credit Limit Dollar | Currency | DLR17_$U2 | 17 |
| 13 | PYMNTPRI | Payment Priority | String | STR3 | 3 |
| 14 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 |
| Key to the Shipping Methods Master (SY03000).
SELECT
['PM Class Master File'].SHIPMTHD AS 'PM Class Master File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PM Class Master File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD |
| 15 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 |
| Key to the Payment Terms Master (SY03300).
SELECT
['PM Class Master File'].PYMTRMID AS 'PM Class Master File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PM Class Master File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID |
| 16 | MINPYTYP | Minimum Payment Type | Integer | GB_Amt_Type | 0 |
| 17 | MINPYDLR | Minimum Payment Dollar | Currency | DLR17_RBS0_UTR$ | 17 |
| 18 | MINPYPCT | Minimum Payment Percent | Integer | INT5_%2 | 5 |
| 19 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 |
| Key to the Currency Setup (MC40200).
SELECT
['PM Class Master File'].CURNCYID AS 'PM Class Master File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Class Master File'].CURNCYID = ['Currency Setup'].CURNCYID |
| 20 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 |
| Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
SELECT
['PM Class Master File'].TAXSCHID AS 'PM Class Master File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Class Master File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID |
| 21 | KPCALHST | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 |
| 22 | KGLDSTHS | Keep GL Dist History | Boolean | CB_Keep_GL_Dist_History | 0 |
| 23 | KPERHIST | Keep Period History | Boolean | CB_Keep_Period_History | 0 |
| 24 | KPTRXHST | Keep Trx History | Boolean | CB_Keep_Trx_History | 0 |
| 25 | TRDDISCT | Trade Discount | Integer | INT4_%2 | 4 |
| 26 | USERDEF1 | User Defined 1 | String | STR20 | 20 |
| 27 | USERDEF2 | User Defined 2 | String | STR20 | 20 |
| 28 | PMAPINDX | PM AP Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMAPINDX AS 'PM Class Master File-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMAPINDX = ['Account Index Master'].ACTINDX |
| 29 | PMCSHIDX | PM Cash Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMCSHIDX AS 'PM Class Master File-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMCSHIDX = ['Account Index Master'].ACTINDX |
| 30 | PMDAVIDX | PM Discount Available Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMDAVIDX AS 'PM Class Master File-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMDAVIDX = ['Account Index Master'].ACTINDX |
| 31 | PMDTKIDX | PM Discount Taken Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMDTKIDX AS 'PM Class Master File-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMDTKIDX = ['Account Index Master'].ACTINDX |
| 32 | PMFINIDX | PM Finance Charge Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMFINIDX AS 'PM Class Master File-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMFINIDX = ['Account Index Master'].ACTINDX |
| 33 | PMMSCHIX | PM Misc Charges Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMMSCHIX AS 'PM Class Master File-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMMSCHIX = ['Account Index Master'].ACTINDX |
| 34 | PMFRTIDX | PM Freight Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMFRTIDX AS 'PM Class Master File-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMFRTIDX = ['Account Index Master'].ACTINDX |
| 35 | PMTAXIDX | PM Tax Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMTAXIDX AS 'PM Class Master File-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMTAXIDX = ['Account Index Master'].ACTINDX |
| 36 | PMWRTIDX | PM Write Offs Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMWRTIDX AS 'PM Class Master File-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMWRTIDX = ['Account Index Master'].ACTINDX |
| 37 | PMPRCHIX | PM Purchases Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMPRCHIX AS 'PM Class Master File-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMPRCHIX = ['Account Index Master'].ACTINDX |
| 38 | PMRTNGIX | PM Retainage Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMRTNGIX AS 'PM Class Master File-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMRTNGIX = ['Account Index Master'].ACTINDX |
| 39 | PMTDSCIX | PM Trade Discount Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PMTDSCIX AS 'PM Class Master File-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PMTDSCIX = ['Account Index Master'].ACTINDX |
| 40 | ACPURIDX | Accrued Purchases Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].ACPURIDX AS 'PM Class Master File-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].ACPURIDX = ['Account Index Master'].ACTINDX |
| 41 | PURPVIDX | Purchase Price Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['PM Class Master File'].PURPVIDX AS 'PM Class Master File-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PM Class Master File'].PURPVIDX = ['Account Index Master'].ACTINDX |
| 42 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 |
| Key to the CM Checkbook Master (CM00100).
SELECT
['PM Class Master File'].CHEKBKID AS 'PM Class Master File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Class Master File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID |
| 43 | MODIFDT | Modified Date | Date | DT | 8 |
| 44 | CREATDDT | Created Date | Date | DT | 8 |
| 45 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 |
| Key to the Multicurrency Rate Type Setup (MC40100).
SELECT
['PM Class Master File'].RATETPID AS 'PM Class Master File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PM00100 AS ['PM Class Master File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PM Class Master File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID |
| 46 | Revalue_Vendor | Revalue Vendor | Boolean | CB Revalue Vendor | 0 |
| 47 | Post_Results_To | Post Results To | Integer | GB | 0 |
| 48 | FREEONBOARD | Free On Board | Integer | DDL_Free_On_Board | 0 |
| 49 | DISGRPER | Discount Grace Period | Integer | INT2_U0 | 2 |
| 50 | DUEGRPER | Due Date Grace Period | Integer | INT2_U0 | 2 |
| 51 | TaxInvRecvd | Tax Invoice Received | Boolean | CB_Tax_Invoice_Received | 0 |
| 52 | CBVAT | Cash Based VAT | Boolean | CB_CashBasedVAT | 0 |
| 53 | ONEPAYPERVENDINV | One Pay Per Vendor Invoice | Integer | GB | 0 |
