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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_NameString64
4VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString64
5VENDSHNM SearchVendor Short NameSTR15String15
6VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString15
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_CodeString15
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_CodeString15
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_CodeString15
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_IDString10
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 ContactSTR60String60
12ADDRESS1 SearchAddress 1STR60String60
13ADDRESS2 SearchAddress 2STR60String60
14ADDRESS3 SearchAddress 3STR60String60
15CITY SearchCitySTR35String35
16STATE SearchStateSTR30_StateString29
17ZIPCODE SearchZip CodeSTR10String10
18COUNTRY SearchCountrySTR60String60
19PHNUMBR1 SearchPhone Number 1Phone_NumberString14
20PHNUMBR2 SearchPhone Number 2Phone_NumberString14
21FAXNUMBR SearchFax NumberSTR14_FAXString14
22UPSZONE SearchUPS ZoneSTR3String3
23SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_IDString15
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 VendorSTR20String20
26TXIDNMBR SearchTax ID NumberTax_ID_NumberString11
27VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger0
28CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 NumberSTR25String25
30PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString15
31TRDDISCT SearchTrade DiscountINT4_%2Integer4
32TEN99TYPE Search1099 Type1099_TypeInteger0
33MINORDER SearchMinimum OrderDLR17_$U2Currency17
34PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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_TypeInteger0
36MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
37MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
38MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger0
39MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency17
40COMMENT1 SearchComment1STR30String30
41COMMENT2 SearchComment2STR30String30
42USERDEF1 SearchUser Defined 1STR20String20
43USERDEF2 SearchUser Defined 2STR20String20
44CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency17
45PYMNTPRI SearchPayment PrioritySTR3String3
46KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
47KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean0
48KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
49KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
50HOLD SearchHoldCB_HoldBoolean0
51PTCSHACF SearchPost To Cash Account FromGBInteger0
52CREDTLMT SearchCredit LimitGBInteger0
53WRITEOFF SearchWriteoffGBInteger0
54MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency17
55SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean0
56PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
57DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String25
58CRTCOMDT SearchCertificate Commencing DateDTDate8
59CRTEXPDT SearchCertificate Expiration DateDTDate8
60RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean0
61XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean0
62PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean0
63PMAPINDX SearchPM AP IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 IndexDLR14Currency14
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_IDString15
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 DateDTDate8
80CREATDDT SearchCreated DateDTDate8
81RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
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 Integer10
83HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency17
84CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency19
85NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer9
86NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer9
87NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer9
88NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer9
89NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer9
90AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency19
91AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency19
92AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency19
93AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency19
94AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency19
95AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency19
96TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency19
97TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency19
98TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency19
99DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency19
100DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency19
101DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency19
102DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency19
103DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency19
104DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency19
105DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency19
106DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency19
107DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency19
108FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency19
109FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency19
110FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency19
111WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
112WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
113WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
114RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency19
115RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency19
116RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency19
117TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency19
118TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency19
119TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency19
120NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer9
121NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer9
122NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer9
123RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency17
124LSTCHNUM SearchLast Check NumberCheck_NumberString20
125LSTCHKDT SearchLast Check DateDTDate8
126LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency17
127LSTINNUM SearchLast Invoice NumberSTR20String20
128LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency17
129LSTPURDT SearchLast Purchase DateDTDate8
130FSTPURDT SearchFirst Purchase DateDTDate8
131CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency17
132UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency17
133DYCHTCLR SearchDays Checks To ClearINT3_U0Integer3
134AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
135AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
136ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
137Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean0
138Post_Results_To SearchPost Results ToGBInteger0
139FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger0
140DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
141DOCFMTID SearchDocument Format IDSTR15_LBUString15
142DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
143GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
144GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
145PHONE3 SearchPhone 3Phone_Number3String14
146TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
147Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency19
148WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency19
149WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency19
150CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
azurecurveProductsSmartList (1493)PathnameSmartList PM Vendor Master File (ASIEXP03)

Leave a Reply

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