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: Pathname

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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 NameSTR64_Vendor_NameString6664
4VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
5VENDSHNM SearchVendor Short NameSTR15String1615
6VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
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 AddressSTR15_Address_CodeString1615
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 FromSTR15_Address_CodeString1615
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 ToSTR15_Address_CodeString1615
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 IDSTR10_Class_IDString1210
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 ContactSTR60String6260
12ADDRESS1 SearchAddress 1STR60String6260
13ADDRESS2 SearchAddress 2STR60String6260
14ADDRESS3 SearchAddress 3STR60String6260
15CITY SearchCitySTR35String3635
16STATE SearchStateSTR30_StateString3029
17ZIPCODE SearchZip CodeSTR10String1210
18COUNTRY SearchCountrySTR60String6260
19PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
20PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
21FAXNUMBR SearchFax NumberSTR14_FAXString2214
22UPSZONE SearchUPS ZoneSTR3String43
23SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 IDSTR15_Tax_Schedule_IDString1615
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 VendorSTR20String2220
26TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
27VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
28CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 NumberSTR25String2625
30PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
31TRDDISCT SearchTrade DiscountINT4_%2Integer24
32TEN99TYPE Search1099 Type1099_TypeInteger20
33MINORDER SearchMinimum OrderDLR17_$U2Currency1017
34PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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 TypeGB_Amt_TypeInteger20
36MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
37MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
38MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
39MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
40COMMENT1 SearchComment1STR30String3230
41COMMENT2 SearchComment2STR30String3230
42USERDEF1 SearchUser Defined 1STR20String2220
43USERDEF2 SearchUser Defined 2STR20String2220
44CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
45PYMNTPRI SearchPayment PrioritySTR3String43
46KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
47KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
48KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
49KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
50HOLD SearchHoldCB_HoldBoolean20
51PTCSHACF SearchPost To Cash Account FromGBInteger20
52CREDTLMT SearchCredit LimitGBInteger20
53WRITEOFF SearchWriteoffGBInteger20
54MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
55SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
56PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
57DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
58CRTCOMDT SearchCertificate Commencing DateDTDate48
59CRTEXPDT SearchCertificate Expiration DateDTDate48
60RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
61XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
62PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
63PMAPINDX SearchPM AP IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexDLR14Currency1014
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 IDSTR15_Checkbook_IDString1615
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 DateDTDate48
80CREATDDT SearchCreated DateDTDate48
81RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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_SequenceASI_LI_10_RULong Integer410
83HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency1017
84CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
85NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer49
86NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer49
87NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer49
88NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer49
89NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer49
90AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency1019
91AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency1019
92AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency1019
93AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency1019
94AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency1019
95AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency1019
96TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency1019
97TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency1019
98TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency1019
99DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency1019
100DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency1019
101DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency1019
102DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency1019
103DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency1019
104DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency1019
105DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency1019
106DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency1019
107DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency1019
108FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency1019
109FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency1019
110FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency1019
111WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
112WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
113WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
114RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency1019
115RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency1019
116RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency1019
117TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency1019
118TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency1019
119TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency1019
120NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer49
121NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer49
122NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer49
123RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency1017
124LSTCHNUM SearchLast Check NumberCheck_NumberString2220
125LSTCHKDT SearchLast Check DateDTDate48
126LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency1017
127LSTINNUM SearchLast Invoice NumberSTR20String2220
128LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency1017
129LSTPURDT SearchLast Purchase DateDTDate48
130FSTPURDT SearchFirst Purchase DateDTDate48
131CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency1017
132UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency1017
133DYCHTCLR SearchDays Checks To ClearINT3_U0Integer23
134AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
135AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
136ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
137Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean20
138Post_Results_To SearchPost Results ToGBInteger20
139FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
140DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
141DOCFMTID SearchDocument Format IDSTR15_LBUString1615
142DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
143GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
144GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
145PHONE3 SearchPhone 3Phone_Number3String2214
146TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
147Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency1019
148WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency1019
149WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency1019
150CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
azurecurveProductsSmartList (1493)PathnameSmartList PM Vendor Master File (ASIEXP03)

Leave a Reply

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