SmartList PM Vendor Master File (ASIEXP03)

azurecurveProductsSmartList (1493)PathnameSmartList PM Vendor Master File (ASIEXP03)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP03

Product: SmartList (1493)
Series:

Display Name: SmartList PM Vendor Master File
Physical Name: ASIEXP03
Technical Name: ASI_PM_Vendor_MSTR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['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
3VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
4VNDCHKNM SearchVendor Check NameStringSTR64_Vendor_Name64
5VENDSHNM SearchVendor Short NameStringSTR1515
6VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['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
7VADCDPAD SearchVendor Address Code - Purchase AddressStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['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
8VADCDSFR SearchVendor Address Code - Ship FromStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['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
9VADCDTRO SearchVendor Address Code - Remit ToStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['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
10VNDCLSID SearchVendor Class IDStringSTR10_Class_ID10
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['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
11VNDCNTCT SearchVendor ContactStringSTR6060
12ADDRESS1 SearchAddress 1StringSTR6060
13ADDRESS2 SearchAddress 2StringSTR6060
14ADDRESS3 SearchAddress 3StringSTR6060
15CITY SearchCityStringSTR3535
16STATE SearchStateStringSTR30_State29
17ZIPCODE SearchZip CodeStringSTR1010
18COUNTRY SearchCountryStringSTR6060
19PHNUMBR1 SearchPhone Number 1StringPhone_Number14
20PHNUMBR2 SearchPhone Number 2StringPhone_Number14
21FAXNUMBR SearchFax NumberStringSTR14_FAX14
22UPSZONE SearchUPS ZoneStringSTR33
23SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['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
24TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['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
25ACNMVNDR SearchAccount Number With VendorStringSTR2020
26TXIDNMBR SearchTax ID NumberStringTax_ID_Number11
27VENDSTTS SearchVendor StatusIntegerDDL_Vendor_Status0
28CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['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
29TXRGNNUM SearchTax Registration NumberStringSTR2525
30PARVENID SearchParent Vendor IDStringSTR_15_Vendor_ID15
31TRDDISCT SearchTrade DiscountIntegerINT4_%24
32TEN99TYPE Search1099 TypeInteger1099_Type0
33MINORDER SearchMinimum OrderCurrencyDLR17_$U217
34PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['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
35MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
36MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
37MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
38MXIAFVND SearchMaximum Invoice Amount For VendorsIntegerGB0
39MAXINDLR SearchMaximum Invoice DollarCurrencyDLR17_$U217
40COMMENT1 SearchComment1StringSTR3030
41COMMENT2 SearchComment2StringSTR3030
42USERDEF1 SearchUser Defined 1StringSTR2020
43USERDEF2 SearchUser Defined 2StringSTR2020
44CRLMTDLR SearchCredit Limit DollarCurrencyDLR17_$U217
45PYMNTPRI SearchPayment PriorityStringSTR33
46KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
47KGLDSTHS SearchKeep GL Dist HistoryBooleanCB_Keep_GL_Dist_History0
48KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
49KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
50HOLD SearchHoldBooleanCB_Hold0
51PTCSHACF SearchPost To Cash Account FromIntegerGB0
52CREDTLMT SearchCredit LimitIntegerGB0
53WRITEOFF SearchWriteoffIntegerGB0
54MXWOFAMT SearchMaximum Write Off AmountCurrencyDLR17_$U217
55SBPPSDED SearchSubject To PPS DeductionsBooleanCB_Subject_To_PPS_Deductions0
56PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
57DXVARNUM SearchDeduction Exemption/Variation NumberStringSTR2525
58CRTCOMDT SearchCertificate Commencing DateDateDT8
59CRTEXPDT SearchCertificate Expiration DateDateDT8
60RTOBUTKN SearchReporting Obligation UndertakenBooleanCB_Reporting_Obligation0
61XPDTOBLG SearchExpiration Date ObligationBooleanCB_Expiration_Date_Obligation0
62PRSPAYEE SearchPrescribed PayeeBooleanCB_Prescribed_Payee0
63PMAPINDX SearchPM AP IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
64PMCSHIDX SearchPM Cash IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
65PMDAVIDX SearchPM Discount Available IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
66PMDTKIDX SearchPM Discount Taken IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
67PMFINIDX SearchPM Finance Charge IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
68PMMSCHIX SearchPM Misc Charges IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
69PMFRTIDX SearchPM Freight IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
70PMTAXIDX SearchPM Tax IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
71PMWRTIDX SearchPM Write Offs IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
72PMPRCHIX SearchPM Purchases IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
73PMRTNGIX SearchPM Retainage IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
74PMTDSCIX SearchPM Trade Discount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
75ACPURIDX SearchAccrued Purchases IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
76PURPVIDX SearchPurchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['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
77NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
78CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['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
79MODIFDT SearchModified DateDateDT8
80CREATDDT SearchCreated DateDateDT8
81RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['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
82ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
83HIESTBAL SearchHighest BalanceCurrencyDLR17_RBS0_UTR$17
84CURRBLNC SearchCurrent BalanceCurrencyDLR19_RBS0_STR$19
85NOINVYTD SearchNumber of Invoices YTDLong IntegerLI_9U09
86NOINVLIF SearchNumber of Invoices LIFELong IntegerLI_9U09
87NOINVLYR SearchNumber of Invoices LYRLong IntegerLI_9U09
88NOPINYTD SearchNumber of Paid Invoices YTDLong IntegerLI_9U09
89NOPILIFE SearchNumber of Paid Invoices LIFELong IntegerLI_9U09
90AMBLDTYD SearchAmount Billed YTDCurrencyDLR19_RBS0_STR$19
91AMBLDLIF SearchAmount Billed LIFECurrencyDLR19_RBS0_STR$19
92AMBLDLYR SearchAmount Billed LYRCurrencyDLR19_RBS0_STR$19
93AMTPDYTD SearchAmount Paid YTDCurrencyDLR19_RBS0_STR$19
94AMTPDLIF SearchAmount Paid LIFECurrencyDLR19_RBS0_STR$19
95AMTPDLYR SearchAmount Paid LYRCurrencyDLR19_RBS0_STR$19
96TEN99AYTD Search1099 Amount YTDCurrencyDLR19_RBS0_STR$19
97TEN99ALIF Search1099 Amount LIFECurrencyDLR19_RBS0_STR$19
98TEN99ALYR Search1099 Amount LYRCurrencyDLR19_RBS0_STR$19
99DISAVYTD SearchDiscount Available YTDCurrencyDLR19_RBS0_STR$19
100DISAVLIF SearchDiscount Available LIFECurrencyDLR19_RBS0_STR$19
101DISAVLYR SearchDiscount Available LYRCurrencyDLR19_RBS0_STR$19
102DISTKYTD SearchDiscount Taken YTDCurrencyDLR19_RBS0_STR$19
103DISTKNLF SearchDiscount Taken LIFECurrencyDLR19_RBS0_STR$19
104DISTKLYR SearchDiscount Taken LYRCurrencyDLR19_RBS0_STR$19
105DISLSYTD SearchDiscount Lost YTDCurrencyDLR19_RBS0_STR$19
106DISLSTLF SearchDiscount Lost LIFECurrencyDLR19_RBS0_STR$19
107DISLSLYR SearchDiscount Lost LYRCurrencyDLR19_RBS0_STR$19
108FINCHLIF SearchFinance Charge LIFECurrencyDLR19_RBS0_STR$19
109FINCHLYR SearchFinance Charge LYRCurrencyDLR19_RBS0_STR$19
110FINCHYTD SearchFinance Charge YTDCurrencyDLR19_RBS0_STR$19
111WROFSYTD SearchWrite Offs YTDCurrencyDLR19_RBS0_STR$19
112WROFSLIF SearchWrite Offs LIFECurrencyDLR19_RBS0_STR$19
113WROFSLYR SearchWrite Offs LYRCurrencyDLR19_RBS0_STR$19
114RTRNSYTD SearchReturns YTDCurrencyDLR19_RBS0_STR$19
115RTRNSLIF SearchReturns LIFECurrencyDLR19_RBS0_STR$19
116RTRNSLYR SearchReturns LYRCurrencyDLR19_RBS0_STR$19
117TRDTKLIF SearchTrade Discounts Taken LIFECurrencyDLR19_RBSO_STR$19
118TRDTLYR SearchTrade Discounts Taken LYRCurrencyDLR19_RBSO_STR$19
119TRDTYTD SearchTrade Discounts Taken YTDCurrencyDLR19_RBSO_STR$19
120NFNCHLIF SearchNumber of Finance Charges LIFELong IntegerLI_9U09
121NFNCHLYR SearchNumber of Finance Charges LYRLong IntegerLI_9U09
122NFNCHYTD SearchNumber of Finance Charges YTDLong IntegerLI_9U09
123RTNGOWED SearchRetainage OwedCurrencyDLR17_RBS0_STR$17
124LSTCHNUM SearchLast Check NumberStringCheck_Number20
125LSTCHKDT SearchLast Check DateDateDT8
126LSTCHAMT SearchLast Check AmountCurrencyDLR17_RBS0_UTR$17
127LSTINNUM SearchLast Invoice NumberStringSTR2020
128LSTINVAM SearchLast Invoice AmountCurrencyDLR17_RBS0_UTR$17
129LSTPURDT SearchLast Purchase DateDateDT8
130FSTPURDT SearchFirst Purchase DateDateDT8
131CURUNPBN SearchCurrent Unapplied Payment BalanceCurrencyDLR17_RBS0_UTR$17
132UNPDFNCH SearchUnpaid Finance ChargesCurrencyDLR17_RBS0_UTR$17
133DYCHTCLR SearchDays Checks To ClearIntegerINT3_U03
134AVGDTPYR SearchAverage Days To Pay - YearIntegerINT3_U03
135AVDTPLIF SearchAverage Days To Pay - LifeIntegerINT3_U03
136ONORDAMT SearchOn Order AmountCurrencyDLR19_RBS0_UTR$19
137Revalue_Vendor SearchRevalue VendorBooleanCB Revalue Vendor0
138Post_Results_To SearchPost Results ToIntegerGB0
139FREEONBOARD SearchFree On BoardIntegerDDL_Free_On_Board0
140DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
141DOCFMTID SearchDocument Format IDStringSTR15_LBU15
142DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
143GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
144GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
145PHONE3 SearchPhone 3StringPhone_Number314
146TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
147Withholding_LIFE SearchWithholding LIFECurrencyDLR19_RBS0_STR$19
148WITHLYR SearchWithholding LYRCurrencyDLR19_RBS0_STR$19
149WITHYTD SearchWithholding YTDCurrencyDLR19_RBS0_STR$19
150CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
151VENDDBA SearchDBAStringSTR6565
azurecurveProductsSmartList (1493)PathnameSmartList PM Vendor Master File (ASIEXP03)

Leave a Reply

Your email address will not be published. Required fields are marked *