| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|
| 1 | ASI_Order_By  | ASI_Order_By | Long Integer | LI_14 | 14 |
| 2 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 |
| Key to the PM Vendor Master File (PM00200).
SELECT
['ASI_PM_Address_MSTR_SmartList'].VENDORID AS 'ASI_PM_Address_MSTR_SmartList-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ASI_PM_Address_MSTR_SmartList'].VENDORID = ['PM Vendor Master File'].VENDORID |
| 3 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 |
| 4 | VENDNAME | Vendor Name | String | STR64_Vendor_Name | 64 |
| 5 | VNDCHKNM | Vendor Check Name | String | STR64_Vendor_Name | 64 |
| 6 | VENDSHNM | Vendor Short Name | String | STR15 | 15 |
| 7 | VNDCLSID | Vendor Class ID | String | STR10_Class_ID | 10 |
| Key to the PM Class Master File (PM00100).
SELECT
['ASI_PM_Address_MSTR_SmartList'].VNDCLSID AS 'ASI_PM_Address_MSTR_SmartList-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['ASI_PM_Address_MSTR_SmartList'].VNDCLSID = ['PM Class Master File'].VNDCLSID |
| 8 | VNDCNTCT | Vendor Contact | String | STR60 | 60 |
| 9 | ADDRESS1 | Address 1 | String | STR60 | 60 |
| 10 | ADDRESS2 | Address 2 | String | STR60 | 60 |
| 11 | ADDRESS3 | Address 3 | String | STR60 | 60 |
| 12 | CITY | City | String | STR35 | 35 |
| 13 | STATE | State | String | STR30_State | 29 |
| 14 | ZIPCODE | Zip Code | String | STR10 | 10 |
| 15 | COUNTRY | Country | String | STR60 | 60 |
| 16 | UPSZONE | UPS Zone | String | STR3 | 3 |
| 17 | PHNUMBR1 | Phone Number 1 | String | Phone_Number | 14 |
| 18 | PHNUMBR2 | Phone Number 2 | String | Phone_Number | 14 |
| 19 | FAXNUMBR | Fax Number | String | STR14_FAX | 14 |
| 20 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 |
| Key to the Shipping Methods Master (SY03000).
SELECT
['ASI_PM_Address_MSTR_SmartList'].SHIPMTHD AS 'ASI_PM_Address_MSTR_SmartList-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['ASI_PM_Address_MSTR_SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD |
| 21 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 |
| Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
SELECT
['ASI_PM_Address_MSTR_SmartList'].TAXSCHID AS 'ASI_PM_Address_MSTR_SmartList-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI_PM_Address_MSTR_SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID |
| 22 | ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | ASI_LI_10_RU | 10 |
| 23 | INET1 | INet1 | String | STR200 | 200 |
| 24 | INET2 | INet2 | String | STR200 | 200 |
| 25 | INET3 | INet3 | String | STR200 | 200 |
| 26 | INET4 | INet4 | String | STR200 | 200 |
| 27 | INET5 | INet5 | String | STR200 | 200 |
| 28 | INET6 | INet6 | String | STR200 | 200 |
| 29 | INET7 | INet7 | String | STR200 | 200 |
| 30 | INET8 | INet8 | String | STR200 | 200 |
| 31 | VADDCDPR | Vendor Address Code - Primary | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
SELECT
['ASI_PM_Address_MSTR_SmartList'].VADDCDPR AS 'ASI_PM_Address_MSTR_SmartList-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['ASI_PM_Address_MSTR_SmartList'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['ASI_PM_Address_MSTR_SmartList'].VENDORID = ['PM Address MSTR'].VENDORID |
| 32 | VADCDPAD | Vendor Address Code - Purchase Address | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
SELECT
['ASI_PM_Address_MSTR_SmartList'].VADCDPAD AS 'ASI_PM_Address_MSTR_SmartList-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['ASI_PM_Address_MSTR_SmartList'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['ASI_PM_Address_MSTR_SmartList'].VENDORID = ['PM Address MSTR'].VENDORID |
| 33 | VADCDSFR | Vendor Address Code - Ship From | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
SELECT
['ASI_PM_Address_MSTR_SmartList'].VADCDSFR AS 'ASI_PM_Address_MSTR_SmartList-Vendor Address Code - Ship From'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['ASI_PM_Address_MSTR_SmartList'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
AND
['ASI_PM_Address_MSTR_SmartList'].VENDORID = ['PM Address MSTR'].VENDORID |
| 34 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
SELECT
['ASI_PM_Address_MSTR_SmartList'].VADCDTRO AS 'ASI_PM_Address_MSTR_SmartList-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['ASI_PM_Address_MSTR_SmartList'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['ASI_PM_Address_MSTR_SmartList'].VENDORID = ['PM Address MSTR'].VENDORID |
| 35 | ACNMVNDR | Account Number With Vendor | String | STR20 | 20 |
| 36 | TXIDNMBR | Tax ID Number | String | Tax_ID_Number | 11 |
| 37 | VENDSTTS | Vendor Status | Integer | DDL_Vendor_Status | 0 |
| 38 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 |
| Key to the Currency Setup (MC40200).
SELECT
['ASI_PM_Address_MSTR_SmartList'].CURNCYID AS 'ASI_PM_Address_MSTR_SmartList-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ASI_PM_Address_MSTR_SmartList'].CURNCYID = ['Currency Setup'].CURNCYID |
| 39 | TXRGNNUM | Tax Registration Number | String | STR25 | 25 |
| 40 | PARVENID | Parent Vendor ID | String | STR_15_Vendor_ID | 15 |
| 41 | TRDDISCT | Trade Discount | Integer | INT4_%2 | 4 |
| 42 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 |
| 43 | MINORDER | Minimum Order | Currency | DLR17_$U2 | 17 |
| 44 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 |
| Key to the Payment Terms Master (SY03300).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PYMTRMID AS 'ASI_PM_Address_MSTR_SmartList-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID |
| 45 | RegKey | RegKey | String | STR128_LBU | 128 |
| 46 | MINPYTYP | Minimum Payment Type | Integer | GB_Amt_Type | 0 |
| 47 | MINPYPCT | Minimum Payment Percent | Integer | INT5_%2 | 5 |
| 48 | MINPYDLR | Minimum Payment Dollar | Currency | DLR17_RBS0_UTR$ | 17 |
| 49 | MXIAFVND | Maximum Invoice Amount For Vendors | Integer | GB | 0 |
| 50 | MAXINDLR | Maximum Invoice Dollar | Currency | DLR17_$U2 | 17 |
| 51 | COMMENT1 | Comment1 | String | STR30 | 30 |
| 52 | COMMENT2 | Comment2 | String | STR30 | 30 |
| 53 | USERDEF1 | User Defined 1 | String | STR20 | 20 |
| 54 | USERDEF2 | User Defined 2 | String | STR20 | 20 |
| 55 | CRLMTDLR | Credit Limit Dollar | Currency | DLR17_$U2 | 17 |
| 56 | PYMNTPRI | Payment Priority | String | STR3 | 3 |
| 57 | KPCALHST | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 |
| 58 | KGLDSTHS | Keep GL Dist History | Boolean | CB_Keep_GL_Dist_History | 0 |
| 59 | KPERHIST | Keep Period History | Boolean | CB_Keep_Period_History | 0 |
| 60 | KPTRXHST | Keep Trx History | Boolean | CB_Keep_Trx_History | 0 |
| 61 | HOLD | Hold | Boolean | CB_Hold | 0 |
| 62 | PTCSHACF | Post To Cash Account From | Integer | GB | 0 |
| 63 | CREDTLMT | Credit Limit | Integer | GB | 0 |
| 64 | WRITEOFF | Writeoff | Integer | GB | 0 |
| 65 | MXWOFAMT | Maximum Write Off Amount | Currency | DLR17_$U2 | 17 |
| 66 | SBPPSDED | Subject To PPS Deductions | Boolean | CB_Subject_To_PPS_Deductions | 0 |
| 67 | PPSTAXRT | PPS Tax Rate | Integer | INT5_%2 | 5 |
| 68 | DXVARNUM | Deduction Exemption/Variation Number | String | STR25 | 25 |
| 69 | CRTCOMDT | Certificate Commencing Date | Date | DT | 8 |
| 70 | CRTEXPDT | Certificate Expiration Date | Date | DT | 8 |
| 71 | RTOBUTKN | Reporting Obligation Undertaken | Boolean | CB_Reporting_Obligation | 0 |
| 72 | XPDTOBLG | Expiration Date Obligation | Boolean | CB_Expiration_Date_Obligation | 0 |
| 73 | PRSPAYEE | Prescribed Payee | Boolean | CB_Prescribed_Payee | 0 |
| 74 | PMAPINDX | PM AP Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMAPINDX AS 'ASI_PM_Address_MSTR_SmartList-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMAPINDX = ['Account Index Master'].ACTINDX |
| 75 | PMCSHIDX | PM Cash Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMCSHIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMCSHIDX = ['Account Index Master'].ACTINDX |
| 76 | PMDAVIDX | PM Discount Available Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMDAVIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMDAVIDX = ['Account Index Master'].ACTINDX |
| 77 | PMDTKIDX | PM Discount Taken Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMDTKIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMDTKIDX = ['Account Index Master'].ACTINDX |
| 78 | PMFINIDX | PM Finance Charge Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMFINIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMFINIDX = ['Account Index Master'].ACTINDX |
| 79 | PMMSCHIX | PM Misc Charges Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMMSCHIX AS 'ASI_PM_Address_MSTR_SmartList-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMMSCHIX = ['Account Index Master'].ACTINDX |
| 80 | PMFRTIDX | PM Freight Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMFRTIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMFRTIDX = ['Account Index Master'].ACTINDX |
| 81 | PMTAXIDX | PM Tax Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMTAXIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMTAXIDX = ['Account Index Master'].ACTINDX |
| 82 | PMWRTIDX | PM Write Offs Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMWRTIDX AS 'ASI_PM_Address_MSTR_SmartList-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMWRTIDX = ['Account Index Master'].ACTINDX |
| 83 | PMPRCHIX | PM Purchases Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMPRCHIX AS 'ASI_PM_Address_MSTR_SmartList-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMPRCHIX = ['Account Index Master'].ACTINDX |
| 84 | PMRTNGIX | PM Retainage Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMRTNGIX AS 'ASI_PM_Address_MSTR_SmartList-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMRTNGIX = ['Account Index Master'].ACTINDX |
| 85 | PMTDSCIX | PM Trade Discount Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PMTDSCIX AS 'ASI_PM_Address_MSTR_SmartList-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PMTDSCIX = ['Account Index Master'].ACTINDX |
| 86 | ACPURIDX | Accrued Purchases Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].ACPURIDX AS 'ASI_PM_Address_MSTR_SmartList-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].ACPURIDX = ['Account Index Master'].ACTINDX |
| 87 | PURPVIDX | Purchase Price Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['ASI_PM_Address_MSTR_SmartList'].PURPVIDX AS 'ASI_PM_Address_MSTR_SmartList-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI_PM_Address_MSTR_SmartList'].PURPVIDX = ['Account Index Master'].ACTINDX |
| 88 | NOTEINDX | Note Index | Currency | DLR14 | 14 |
| Key to the Record Notes Master (SY03900).
SELECT
['ASI_PM_Address_MSTR_SmartList'].NOTEINDX AS 'ASI_PM_Address_MSTR_SmartList-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['ASI_PM_Address_MSTR_SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX |
| 89 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 |
| Key to the CM Checkbook Master (CM00100).
SELECT
['ASI_PM_Address_MSTR_SmartList'].CHEKBKID AS 'ASI_PM_Address_MSTR_SmartList-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['ASI_PM_Address_MSTR_SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID |
| 90 | MODIFDT | Modified Date | Date | DT | 8 |
| 91 | CREATDDT | Created Date | Date | DT | 8 |
| 92 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 |
| Key to the Multicurrency Rate Type Setup (MC40100).
SELECT
['ASI_PM_Address_MSTR_SmartList'].RATETPID AS 'ASI_PM_Address_MSTR_SmartList-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP16 AS ['ASI_PM_Address_MSTR_SmartList']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['ASI_PM_Address_MSTR_SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID |
| 93 | Revalue_Vendor | Revalue Vendor | Boolean | CB Revalue Vendor | 0 |
| 94 | Post_Results_To | Post Results To | Integer | GB | 0 |
| 95 | FREEONBOARD | Free On Board | Integer | DDL_Free_On_Board | 0 |
| 96 | DISGRPER | Discount Grace Period | Integer | INT2_U0 | 2 |
| 97 | DOCFMTID | Document Format ID | String | STR15_LBU | 15 |
| 98 | DUEGRPER | Due Date Grace Period | Integer | INT2_U0 | 2 |
| 99 | GOVCRPID | Governmental Corporate ID | String | STR30_Gov_Corp_ID | 30 |
| 100 | GOVINDID | Governmental Individual ID | String | STR30_Gov_Indiv_ID | 30 |
| 101 | PHONE3 | Phone 3 | String | Phone_Number3 | 14 |
| 102 | TaxInvRecvd | Tax Invoice Received | Boolean | CB_Tax_Invoice_Received | 0 |
| 103 | Withholding_LIFE | Withholding LIFE | Currency | DLR19_RBS0_STR$ | 19 |
| 104 | WITHLYR | Withholding LYR | Currency | DLR19_RBS0_STR$ | 19 |
| 105 | WITHYTD | Withholding YTD | Currency | DLR19_RBS0_STR$ | 19 |
