Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP03
Product: SmartList (1493)
Series: Pathname
Display Name: SmartList PM Vendor Master File Group Display Name: SmartList Master
Physical Name: ASIEXP03
Technical Name: ASI_PM_Vendor_MSTR_Explorer
Group Technical Name: ASI_Explorer_Logical_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ASI_Order_By ![]() | ASI_Order_By | LI_14 | Long Integer | 14 | |
2 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].VENDORID AS 'SmartList PM Vendor Master File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SmartList PM Vendor Master File'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
3 | VENDNAME ![]() | Vendor Name | STR64_Vendor_Name | String | 64 | |
4 | VNDCHKNM ![]() | Vendor Check Name | STR64_Vendor_Name | String | 64 | |
5 | VENDSHNM ![]() | Vendor Short Name | STR15 | String | 15 | |
6 | VADDCDPR ![]() | Vendor Address Code - Primary | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].VADDCDPR AS 'SmartList PM Vendor Master File-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList PM Vendor Master File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
7 | VADCDPAD ![]() | Vendor Address Code - Purchase Address | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].VADCDPAD AS 'SmartList PM Vendor Master File-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList PM Vendor Master File'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
8 | VADCDSFR ![]() | Vendor Address Code - Ship From | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].VADCDSFR AS 'SmartList PM Vendor Master File-Vendor Address Code - Ship From'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList PM Vendor Master File'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
9 | VADCDTRO ![]() | Vendor Address Code - Remit To | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].VADCDTRO AS 'SmartList PM Vendor Master File-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList PM Vendor Master File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
10 | VNDCLSID ![]() | Vendor Class ID | STR10_Class_ID | String | 10 | |
Key to the PM Class Master File (PM00100).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].VNDCLSID AS 'SmartList PM Vendor Master File-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['SmartList PM Vendor Master File'].VNDCLSID = ['PM Class Master File'].VNDCLSID | ||||||
11 | VNDCNTCT ![]() | Vendor Contact | STR60 | String | 60 | |
12 | ADDRESS1 ![]() | Address 1 | STR60 | String | 60 | |
13 | ADDRESS2 ![]() | Address 2 | STR60 | String | 60 | |
14 | ADDRESS3 ![]() | Address 3 | STR60 | String | 60 | |
15 | CITY ![]() | City | STR35 | String | 35 | |
16 | STATE ![]() | State | STR30_State | String | 29 | |
17 | ZIPCODE ![]() | Zip Code | STR10 | String | 10 | |
18 | COUNTRY ![]() | Country | STR60 | String | 60 | |
19 | PHNUMBR1 ![]() | Phone Number 1 | Phone_Number | String | 14 | |
20 | PHNUMBR2 ![]() | Phone Number 2 | Phone_Number | String | 14 | |
21 | FAXNUMBR ![]() | Fax Number | STR14_FAX | String | 14 | |
22 | UPSZONE ![]() | UPS Zone | STR3 | String | 3 | |
23 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].SHIPMTHD AS 'SmartList PM Vendor Master File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SmartList PM Vendor Master File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
24 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].TAXSCHID AS 'SmartList PM Vendor Master File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList PM Vendor Master File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
25 | ACNMVNDR ![]() | Account Number With Vendor | STR20 | String | 20 | |
26 | TXIDNMBR ![]() | Tax ID Number | Tax_ID_Number | String | 11 | |
27 | VENDSTTS ![]() | Vendor Status | DDL_Vendor_Status | Integer | 0 | |
28 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].CURNCYID AS 'SmartList PM Vendor Master File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList PM Vendor Master File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
29 | TXRGNNUM ![]() | Tax Registration Number | STR25 | String | 25 | |
30 | PARVENID ![]() | Parent Vendor ID | STR_15_Vendor_ID | String | 15 | |
31 | TRDDISCT ![]() | Trade Discount | INT4_%2 | Integer | 4 | |
32 | TEN99TYPE ![]() | 1099 Type | 1099_Type | Integer | 0 | |
33 | MINORDER ![]() | Minimum Order | DLR17_$U2 | Currency | 17 | |
34 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PYMTRMID AS 'SmartList PM Vendor Master File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['SmartList PM Vendor Master File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
35 | MINPYTYP ![]() | Minimum Payment Type | GB_Amt_Type | Integer | 0 | |
36 | MINPYPCT ![]() | Minimum Payment Percent | INT5_%2 | Integer | 5 | |
37 | MINPYDLR ![]() | Minimum Payment Dollar | DLR17_RBS0_UTR$ | Currency | 17 | |
38 | MXIAFVND ![]() | Maximum Invoice Amount For Vendors | GB | Integer | 0 | |
39 | MAXINDLR ![]() | Maximum Invoice Dollar | DLR17_$U2 | Currency | 17 | |
40 | COMMENT1 ![]() | Comment1 | STR30 | String | 30 | |
41 | COMMENT2 ![]() | Comment2 | STR30 | String | 30 | |
42 | USERDEF1 ![]() | User Defined 1 | STR20 | String | 20 | |
43 | USERDEF2 ![]() | User Defined 2 | STR20 | String | 20 | |
44 | CRLMTDLR ![]() | Credit Limit Dollar | DLR17_$U2 | Currency | 17 | |
45 | PYMNTPRI ![]() | Payment Priority | STR3 | String | 3 | |
46 | KPCALHST ![]() | Keep Calendar History | CB_Keep_Calendar_History | Boolean | 0 | |
47 | KGLDSTHS ![]() | Keep GL Dist History | CB_Keep_GL_Dist_History | Boolean | 0 | |
48 | KPERHIST ![]() | Keep Period History | CB_Keep_Period_History | Boolean | 0 | |
49 | KPTRXHST ![]() | Keep Trx History | CB_Keep_Trx_History | Boolean | 0 | |
50 | HOLD ![]() | Hold | CB_Hold | Boolean | 0 | |
51 | PTCSHACF ![]() | Post To Cash Account From | GB | Integer | 0 | |
52 | CREDTLMT ![]() | Credit Limit | GB | Integer | 0 | |
53 | WRITEOFF ![]() | Writeoff | GB | Integer | 0 | |
54 | MXWOFAMT ![]() | Maximum Write Off Amount | DLR17_$U2 | Currency | 17 | |
55 | SBPPSDED ![]() | Subject To PPS Deductions | CB_Subject_To_PPS_Deductions | Boolean | 0 | |
56 | PPSTAXRT ![]() | PPS Tax Rate | INT5_%2 | Integer | 5 | |
57 | DXVARNUM ![]() | Deduction Exemption/Variation Number | STR25 | String | 25 | |
58 | CRTCOMDT ![]() | Certificate Commencing Date | DT | Date | 8 | |
59 | CRTEXPDT ![]() | Certificate Expiration Date | DT | Date | 8 | |
60 | RTOBUTKN ![]() | Reporting Obligation Undertaken | CB_Reporting_Obligation | Boolean | 0 | |
61 | XPDTOBLG ![]() | Expiration Date Obligation | CB_Expiration_Date_Obligation | Boolean | 0 | |
62 | PRSPAYEE ![]() | Prescribed Payee | CB_Prescribed_Payee | Boolean | 0 | |
63 | PMAPINDX ![]() | PM AP Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMAPINDX AS 'SmartList PM Vendor Master File-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMAPINDX = ['Account Index Master'].ACTINDX | ||||||
64 | PMCSHIDX ![]() | PM Cash Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMCSHIDX AS 'SmartList PM Vendor Master File-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMCSHIDX = ['Account Index Master'].ACTINDX | ||||||
65 | PMDAVIDX ![]() | PM Discount Available Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMDAVIDX AS 'SmartList PM Vendor Master File-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMDAVIDX = ['Account Index Master'].ACTINDX | ||||||
66 | PMDTKIDX ![]() | PM Discount Taken Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMDTKIDX AS 'SmartList PM Vendor Master File-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMDTKIDX = ['Account Index Master'].ACTINDX | ||||||
67 | PMFINIDX ![]() | PM Finance Charge Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMFINIDX AS 'SmartList PM Vendor Master File-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMFINIDX = ['Account Index Master'].ACTINDX | ||||||
68 | PMMSCHIX ![]() | PM Misc Charges Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMMSCHIX AS 'SmartList PM Vendor Master File-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMMSCHIX = ['Account Index Master'].ACTINDX | ||||||
69 | PMFRTIDX ![]() | PM Freight Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMFRTIDX AS 'SmartList PM Vendor Master File-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMFRTIDX = ['Account Index Master'].ACTINDX | ||||||
70 | PMTAXIDX ![]() | PM Tax Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMTAXIDX AS 'SmartList PM Vendor Master File-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMTAXIDX = ['Account Index Master'].ACTINDX | ||||||
71 | PMWRTIDX ![]() | PM Write Offs Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMWRTIDX AS 'SmartList PM Vendor Master File-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMWRTIDX = ['Account Index Master'].ACTINDX | ||||||
72 | PMPRCHIX ![]() | PM Purchases Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMPRCHIX AS 'SmartList PM Vendor Master File-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMPRCHIX = ['Account Index Master'].ACTINDX | ||||||
73 | PMRTNGIX ![]() | PM Retainage Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMRTNGIX AS 'SmartList PM Vendor Master File-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMRTNGIX = ['Account Index Master'].ACTINDX | ||||||
74 | PMTDSCIX ![]() | PM Trade Discount Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PMTDSCIX AS 'SmartList PM Vendor Master File-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PMTDSCIX = ['Account Index Master'].ACTINDX | ||||||
75 | ACPURIDX ![]() | Accrued Purchases Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].ACPURIDX AS 'SmartList PM Vendor Master File-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].ACPURIDX = ['Account Index Master'].ACTINDX | ||||||
76 | PURPVIDX ![]() | Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].PURPVIDX AS 'SmartList PM Vendor Master File-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList PM Vendor Master File'].PURPVIDX = ['Account Index Master'].ACTINDX | ||||||
77 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].NOTEINDX AS 'SmartList PM Vendor Master File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList PM Vendor Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
78 | CHEKBKID ![]() | Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].CHEKBKID AS 'SmartList PM Vendor Master File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList PM Vendor Master File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
79 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
80 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
81 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['SmartList PM Vendor Master File'].RATETPID AS 'SmartList PM Vendor Master File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP03 AS ['SmartList PM Vendor Master File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SmartList PM Vendor Master File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
82 | ASI_Favorite_Sequence ![]() | ASI_Favorite_Sequence | ASI_LI_10_RU | Long Integer | 10 | |
83 | HIESTBAL ![]() | Highest Balance | DLR17_RBS0_UTR$ | Currency | 17 | |
84 | CURRBLNC ![]() | Current Balance | DLR19_RBS0_STR$ | Currency | 19 | |
85 | NOINVYTD ![]() | Number of Invoices YTD | LI_9U0 | Long Integer | 9 | |
86 | NOINVLIF ![]() | Number of Invoices LIFE | LI_9U0 | Long Integer | 9 | |
87 | NOINVLYR ![]() | Number of Invoices LYR | LI_9U0 | Long Integer | 9 | |
88 | NOPINYTD ![]() | Number of Paid Invoices YTD | LI_9U0 | Long Integer | 9 | |
89 | NOPILIFE ![]() | Number of Paid Invoices LIFE | LI_9U0 | Long Integer | 9 | |
90 | AMBLDTYD ![]() | Amount Billed YTD | DLR19_RBS0_STR$ | Currency | 19 | |
91 | AMBLDLIF ![]() | Amount Billed LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
92 | AMBLDLYR ![]() | Amount Billed LYR | DLR19_RBS0_STR$ | Currency | 19 | |
93 | AMTPDYTD ![]() | Amount Paid YTD | DLR19_RBS0_STR$ | Currency | 19 | |
94 | AMTPDLIF ![]() | Amount Paid LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
95 | AMTPDLYR ![]() | Amount Paid LYR | DLR19_RBS0_STR$ | Currency | 19 | |
96 | TEN99AYTD ![]() | 1099 Amount YTD | DLR19_RBS0_STR$ | Currency | 19 | |
97 | TEN99ALIF ![]() | 1099 Amount LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
98 | TEN99ALYR ![]() | 1099 Amount LYR | DLR19_RBS0_STR$ | Currency | 19 | |
99 | DISAVYTD ![]() | Discount Available YTD | DLR19_RBS0_STR$ | Currency | 19 | |
100 | DISAVLIF ![]() | Discount Available LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
101 | DISAVLYR ![]() | Discount Available LYR | DLR19_RBS0_STR$ | Currency | 19 | |
102 | DISTKYTD ![]() | Discount Taken YTD | DLR19_RBS0_STR$ | Currency | 19 | |
103 | DISTKNLF ![]() | Discount Taken LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
104 | DISTKLYR ![]() | Discount Taken LYR | DLR19_RBS0_STR$ | Currency | 19 | |
105 | DISLSYTD ![]() | Discount Lost YTD | DLR19_RBS0_STR$ | Currency | 19 | |
106 | DISLSTLF ![]() | Discount Lost LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
107 | DISLSLYR ![]() | Discount Lost LYR | DLR19_RBS0_STR$ | Currency | 19 | |
108 | FINCHLIF ![]() | Finance Charge LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
109 | FINCHLYR ![]() | Finance Charge LYR | DLR19_RBS0_STR$ | Currency | 19 | |
110 | FINCHYTD ![]() | Finance Charge YTD | DLR19_RBS0_STR$ | Currency | 19 | |
111 | WROFSYTD ![]() | Write Offs YTD | DLR19_RBS0_STR$ | Currency | 19 | |
112 | WROFSLIF ![]() | Write Offs LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
113 | WROFSLYR ![]() | Write Offs LYR | DLR19_RBS0_STR$ | Currency | 19 | |
114 | RTRNSYTD ![]() | Returns YTD | DLR19_RBS0_STR$ | Currency | 19 | |
115 | RTRNSLIF ![]() | Returns LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
116 | RTRNSLYR ![]() | Returns LYR | DLR19_RBS0_STR$ | Currency | 19 | |
117 | TRDTKLIF ![]() | Trade Discounts Taken LIFE | DLR19_RBSO_STR$ | Currency | 19 | |
118 | TRDTLYR ![]() | Trade Discounts Taken LYR | DLR19_RBSO_STR$ | Currency | 19 | |
119 | TRDTYTD ![]() | Trade Discounts Taken YTD | DLR19_RBSO_STR$ | Currency | 19 | |
120 | NFNCHLIF ![]() | Number of Finance Charges LIFE | LI_9U0 | Long Integer | 9 | |
121 | NFNCHLYR ![]() | Number of Finance Charges LYR | LI_9U0 | Long Integer | 9 | |
122 | NFNCHYTD ![]() | Number of Finance Charges YTD | LI_9U0 | Long Integer | 9 | |
123 | RTNGOWED ![]() | Retainage Owed | DLR17_RBS0_STR$ | Currency | 17 | |
124 | LSTCHNUM ![]() | Last Check Number | Check_Number | String | 20 | |
125 | LSTCHKDT ![]() | Last Check Date | DT | Date | 8 | |
126 | LSTCHAMT ![]() | Last Check Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
127 | LSTINNUM ![]() | Last Invoice Number | STR20 | String | 20 | |
128 | LSTINVAM ![]() | Last Invoice Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
129 | LSTPURDT ![]() | Last Purchase Date | DT | Date | 8 | |
130 | FSTPURDT ![]() | First Purchase Date | DT | Date | 8 | |
131 | CURUNPBN ![]() | Current Unapplied Payment Balance | DLR17_RBS0_UTR$ | Currency | 17 | |
132 | UNPDFNCH ![]() | Unpaid Finance Charges | DLR17_RBS0_UTR$ | Currency | 17 | |
133 | DYCHTCLR ![]() | Days Checks To Clear | INT3_U0 | Integer | 3 | |
134 | AVGDTPYR ![]() | Average Days To Pay - Year | INT3_U0 | Integer | 3 | |
135 | AVDTPLIF ![]() | Average Days To Pay - Life | INT3_U0 | Integer | 3 | |
136 | ONORDAMT ![]() | On Order Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
137 | Revalue_Vendor ![]() | Revalue Vendor | CB Revalue Vendor | Boolean | 0 | |
138 | Post_Results_To ![]() | Post Results To | GB | Integer | 0 | |
139 | FREEONBOARD ![]() | Free On Board | DDL_Free_On_Board | Integer | 0 | |
140 | DISGRPER ![]() | Discount Grace Period | INT2_U0 | Integer | 2 | |
141 | DOCFMTID ![]() | Document Format ID | STR15_LBU | String | 15 | |
142 | DUEGRPER ![]() | Due Date Grace Period | INT2_U0 | Integer | 2 | |
143 | GOVCRPID ![]() | Governmental Corporate ID | STR30_Gov_Corp_ID | String | 30 | |
144 | GOVINDID ![]() | Governmental Individual ID | STR30_Gov_Indiv_ID | String | 30 | |
145 | PHONE3 ![]() | Phone 3 | Phone_Number3 | String | 14 | |
146 | TaxInvRecvd ![]() | Tax Invoice Received | CB_Tax_Invoice_Received | Boolean | 0 | |
147 | Withholding_LIFE ![]() | Withholding LIFE | DLR19_RBS0_STR$ | Currency | 19 | |
148 | WITHLYR ![]() | Withholding LYR | DLR19_RBS0_STR$ | Currency | 19 | |
149 | WITHYTD ![]() | Withholding YTD | DLR19_RBS0_STR$ | Currency | 19 | |
150 | CPRCSTNM ![]() | Corporate Customer Number | STR15_RM_Customer_Number | String | 15 |