SmartList Payables Transactions (ASIEXP09)

azurecurveProductsSmartList (1493)PathnameSmartList Payables Transactions (ASIEXP09)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Payables Transactions
Physical Name: ASIEXP09
Technical Name: ASI_PM_Document_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
2BACHNUMB SearchBatch NumberSTR15_LBAUString15
3BCHSOURC SearchBatch SourceSTR15String15
4VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].VENDORID AS 'SmartList Payables Transactions-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SmartList Payables Transactions'].VENDORID = ['PM Vendor Master File'].VENDORID
5DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
6DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
7ASI_Document_Status SearchASI_Document_StatusINTInteger0
8SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].SOURCDOC AS 'SmartList Payables Transactions-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['SmartList Payables Transactions'].SOURCDOC = ['Source Document Master'].SOURCDOC
9DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
10DOCDATE SearchDocument DateDTDate8
11PSTGDATE SearchPosting DateDTDate8
12VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].VADDCDPR AS 'SmartList Payables Transactions-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Payables Transactions'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
13PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PYMTRMID AS 'SmartList Payables Transactions-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Payables Transactions'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
14TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].TAXSCHID AS 'SmartList Payables Transactions-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Payables Transactions'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
15DUEDATE SearchDue DateDTDate8
16DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
17DISCDATE SearchDiscount DateDTDate8
18PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency17
19CHRGAMNT SearchCharge AmountDLR19_RBSO_UTR$Currency19
20CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency19
21CAMCBKID SearchCash Amount Checkbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].CAMCBKID AS 'SmartList Payables Transactions-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Payables Transactions'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
22CDOCNMBR SearchCash Document NumberSTR20_Document_NumberString20
23CAMTDATE SearchCash Amount DateDTDate8
24CAMPMTNM SearchCash Amount Payment NumberSTR20_LBAUString20
25CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency19
26CHAMCBID SearchCheck Amount Checkbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].CHAMCBID AS 'SmartList Payables Transactions-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Payables Transactions'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
27CHEKDATE SearchCheck DateDATEDate6
28CAMPYNBR SearchCheck Amount Payment NumberSTR20_LBAUString20
29CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency19
30CCAMPYNM SearchCredit Card Amount Payment NumberSTR20_LBAUString20
31CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
32CARDNAME SearchCard NameSTR15_Card_NameString15
33CCRCTNUM SearchCredit Card Receipt NumberSTR20_Document_NumberString20
34CRCARDDT SearchCredit Card DateDATEDate6
35CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].CURNCYID AS 'SmartList Payables Transactions-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Payables Transactions'].CURNCYID = ['Currency Setup'].CURNCYID
36CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].CHEKBKID AS 'SmartList Payables Transactions-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Payables Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
37TRXDSCRN SearchTransaction DescriptionSTR30String30
38UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency17
39TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
41FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
42TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency17
43MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
44PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
45SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].SHIPMTHD AS 'SmartList Payables Transactions-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Payables Transactions'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
46DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
47DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
48APDSTKAM SearchApplied Discount Taken AmountDLR17_RBS0_UTR$Currency17
49WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
50CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency17
51TXENGCLD SearchTax Engine CalledYNBoolean0
52PMWRKMSG SearchPM WORK MessagesML_PM_WORK_MessagesLong Integer0
53PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer0
54GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
55PGRAMSBJ SearchPercent Of Gross Amount SubjectINT5_RBS2_U%Integer5
56PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
57PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
58POSTED SearchPostedTrue/FalseBoolean0
59APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency17
60VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
61CNTRLTYP SearchControl TypeINT1Integer1
62MODIFDT SearchModified DateDTDate8
63MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].MDFUSRID AS 'SmartList Payables Transactions-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Payables Transactions'].MDFUSRID = ['Users Master'].USERID
64POSTEDDT SearchPosted DateDATEDate6
65PTDUSRID SearchPosted User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PTDUSRID AS 'SmartList Payables Transactions-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Payables Transactions'].PTDUSRID = ['Users Master'].USERID
66NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].NOTEINDX AS 'SmartList Payables Transactions-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Payables Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX
67BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency19
68BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency19
69BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency19
70PCHSCHID SearchPurchase Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PCHSCHID AS 'SmartList Payables Transactions-Purchase Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Payables Transactions'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
71FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].FRTSCHID AS 'SmartList Payables Transactions-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Payables Transactions'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72MSCSCHID SearchMisc Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].MSCSCHID AS 'SmartList Payables Transactions-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Payables Transactions'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73PRINTED SearchPrintedCBBoolean0

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
74PRCTDISC SearchPercent DiscountINT5_%2Integer5
75RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency17
76ICTRX SearchIC TRXCB_IC_TRXBoolean0

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
77ICDISTS SearchICDistsBooleanBoolean0

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
78PMICMSGS SearchICMessagesML_IC_Post_MessagesLong Integer0
Error messages from posting an Intercompany Transaction.

Click to show/hide Intercompany posting error messages


1	The currency ID is missing.
2	A destination company does not have access to this currency ID.
3	The currency ID is inactive for a destination company. 
4	A rate type ID is missing for a destination company. 
5	Rate type ID is not associated with the currency ID for a destination
   company.
6	An exchange table ID is missing for a destination company. 
7	A destination company does not have access to an exchange table ID. 
8	An exchange table ID is inactive for a destination company. 
9	An exchange rate does not exist for a destination company. 
10	An exchange rate has expired for a destination company. 
11	Cannot post intercompany multicurrency transactions to a recurring batch. 
12	A rounding account missing for a destination company.
13	A distribution type is invalid for a destination company distribution.
14	A destination company distribution contains MDA information.
15	A destination company ID does not exist; please select another company ID.
16	The user does not have access to a destination company.
17	A destination company does not have a functional currency set up.
18	Destination functional currency doesn't match originating functional currency.
19	No relationship exists between originating company and a destination company.
20	Due To / Due From account not specified.
21	The rounding account does not exist for the originating company.
22	Unknown SQL error occurred.
23	Intrastat information is missing or invalid.
24	The goods value for Intrastat exceeds the document total.
25	Transaction has successfully posted.
79Tax_Date SearchTax DateDTDate8
80DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency17
81TRXSORCE SearchTRX SourceSTR13String13
82VOIDED SearchVoidedCBBoolean0
83HOLD SearchHoldCB_HoldBoolean0
84DINVPDOF SearchDate Invoice Paid OffDTDate8
85PYENTTYP SearchPayment Entry TypeGBInteger0
86TTLPYMTS SearchTotal PaymentsDLR19_RBS0_UTR$Currency19
87DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
88VOIDPDATE SearchVoid GL Posting DateDTDate8
89ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
90DCSTATUS SearchDocument StatusDDL_Doc_StatusInteger0
91PMNTNMBR SearchPayment NumberSTR20_LBAUString20
92CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].CURRNIDX AS 'SmartList Payables Transactions-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Payables Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX
93RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].RATETPID AS 'SmartList Payables Transactions-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Payables Transactions'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
94EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].EXGTBLID AS 'SmartList Payables Transactions-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SmartList Payables Transactions'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
95XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
96EXCHDATE SearchExchange DateDT_DateDate6
97TIME1 SearchTimeTM6Time6
98RTCLCMTD SearchRate Calculation MethodGBInteger0
99ORCTRXAM SearchOriginating Current Trx AmountDLR17_RBS0_UTR$Currency17
100OPURAMT SearchOriginating Purchases AmountDLR17_RBS0_UTR$Currency17
101ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
102OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency17
103ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
104ORCASAMT SearchOriginating Cash AmountDLR19_RBSO_UTR$Currency19
105ORCHKAMT SearchOriginating Check AmountDLR19_RBSO_UTR$Currency19
106ORCHKTTL SearchOriginating Check TotalDLR19_RBS0_UTR$Currency19
107ORCCDAMT SearchOriginating Credit Card AmountDLR19_RBSO_UTR$Currency19
108ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency17
109ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
110ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
111ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
112ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
113ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency17
114OBKPURAMT SearchOriginating Backout Purchases AmountDLR19_RBS0_UTR$Currency19
115ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency19
116ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency19
117UNGANLOS SearchUnrealized Gain-Loss AmountDLR19_$S2Currency19
118RMMCERRS SearchRM MC Posting Error MessagesRM_MC_Posting_Error_MessagesLong Integer0
119OCHGAMT SearchOriginating Charge AmountDLR19_RBSO_UTR$Currency19
120ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency17
121ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency17
122ORGAPDISCTKN SearchOriginating Applied Discount Taken AmountDLR17_RBS0_UTR$Currency17
123OTOTPAY SearchOriginating Total PaymentsDLR19_RBS0_UTR$Currency19
124OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency17
125DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
126MCTRXSTT SearchMC Transaction StateINT1Integer1
127VENDNAME SearchVendor NameSTR64_Vendor_NameString64
128VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString64
129VENDSHNM SearchVendor Short NameSTR15String15
130VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].VADCDPAD AS 'SmartList Payables Transactions-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Payables Transactions'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
131VADCDSFR SearchVendor Address Code - Ship FromSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].VADCDSFR AS 'SmartList Payables Transactions-Vendor Address Code - Ship From'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Payables Transactions'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
132VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].VADCDTRO AS 'SmartList Payables Transactions-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Payables Transactions'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
133VNDCLSID SearchVendor Class IDSTR10_Class_IDString10
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].VNDCLSID AS 'SmartList Payables Transactions-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['SmartList Payables Transactions'].VNDCLSID = ['PM Class Master File'].VNDCLSID
134VNDCNTCT SearchVendor ContactSTR60String60
135ADDRESS1 SearchAddress 1STR60String60
136ADDRESS2 SearchAddress 2STR60String60
137ADDRESS3 SearchAddress 3STR60String60
138CITY SearchCitySTR35String35
139STATE SearchStateSTR30_StateString29
140ZIPCODE SearchZip CodeSTR10String10
141COUNTRY SearchCountrySTR60String60
142PHNUMBR1 SearchPhone Number 1Phone_NumberString14
143PHNUMBR2 SearchPhone Number 2Phone_NumberString14
144FAXNUMBR SearchFax NumberSTR14_FAXString14
145UPSZONE SearchUPS ZoneSTR3String3
146ACNMVNDR SearchAccount Number With VendorSTR20String20
147TXIDNMBR SearchTax ID NumberTax_ID_NumberString11
148VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger0
149TXRGNNUM SearchTax Registration NumberSTR25String25
150PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString15
151TRDDISCT SearchTrade DiscountINT4_%2Integer4
152TEN99TYPE Search1099 Type1099_TypeInteger0
153MINORDER SearchMinimum OrderDLR17_$U2Currency17
154MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
155MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
156MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
157MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger0
158MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency17
159COMMENT1 SearchComment1STR30String30
160COMMENT2 SearchComment2STR30String30
161USERDEF1 SearchUser Defined 1STR20String20
162USERDEF2 SearchUser Defined 2STR20String20
163CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency17
164PYMNTPRI SearchPayment PrioritySTR3String3
165KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
166KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean0
167KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
168KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
169PTCSHACF SearchPost To Cash Account FromGBInteger0
170CREDTLMT SearchCredit LimitGBInteger0
171WRITEOFF SearchWriteoffGBInteger0
172MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency17
173SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean0
174DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String25
175CRTCOMDT SearchCertificate Commencing DateDTDate8
176CRTEXPDT SearchCertificate Expiration DateDTDate8
177RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean0
178XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean0
179PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean0
180PMAPINDX SearchPM AP IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMAPINDX AS 'SmartList Payables Transactions-PM AP Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMAPINDX = ['Account Index Master'].ACTINDX
181PMCSHIDX SearchPM Cash IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMCSHIDX AS 'SmartList Payables Transactions-PM Cash Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMCSHIDX = ['Account Index Master'].ACTINDX
182PMDAVIDX SearchPM Discount Available IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMDAVIDX AS 'SmartList Payables Transactions-PM Discount Available Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMDAVIDX = ['Account Index Master'].ACTINDX
183PMDTKIDX SearchPM Discount Taken IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMDTKIDX AS 'SmartList Payables Transactions-PM Discount Taken Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMDTKIDX = ['Account Index Master'].ACTINDX
184PMFINIDX SearchPM Finance Charge IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMFINIDX AS 'SmartList Payables Transactions-PM Finance Charge Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMFINIDX = ['Account Index Master'].ACTINDX
185PMMSCHIX SearchPM Misc Charges IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMMSCHIX AS 'SmartList Payables Transactions-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMMSCHIX = ['Account Index Master'].ACTINDX
186PMFRTIDX SearchPM Freight IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMFRTIDX AS 'SmartList Payables Transactions-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMFRTIDX = ['Account Index Master'].ACTINDX
187PMTAXIDX SearchPM Tax IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMTAXIDX AS 'SmartList Payables Transactions-PM Tax Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMTAXIDX = ['Account Index Master'].ACTINDX
188PMWRTIDX SearchPM Write Offs IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMWRTIDX AS 'SmartList Payables Transactions-PM Write Offs Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMWRTIDX = ['Account Index Master'].ACTINDX
189PMPRCHIX SearchPM Purchases IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMPRCHIX AS 'SmartList Payables Transactions-PM Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMPRCHIX = ['Account Index Master'].ACTINDX
190PMRTNGIX SearchPM Retainage IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMRTNGIX AS 'SmartList Payables Transactions-PM Retainage Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMRTNGIX = ['Account Index Master'].ACTINDX
191PMTDSCIX SearchPM Trade Discount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PMTDSCIX AS 'SmartList Payables Transactions-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PMTDSCIX = ['Account Index Master'].ACTINDX
192ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].ACPURIDX AS 'SmartList Payables Transactions-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].ACPURIDX = ['Account Index Master'].ACTINDX
193PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Payables Transactions'].PURPVIDX AS 'SmartList Payables Transactions-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Payables Transactions'].PURPVIDX = ['Account Index Master'].ACTINDX
194Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean0
195Post_Results_To SearchPost Results ToGBInteger0
196FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger0
197HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency17
198CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency19
199NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer9
200NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer9
201NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer9
202NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer9
203NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer9
204AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency19
205AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency19
206AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency19
207AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency19
208AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency19
209AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency19
210TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency19
211TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency19
212TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency19
213DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency19
214DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency19
215DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency19
216DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency19
217DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency19
218DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency19
219DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency19
220DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency19
221DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency19
222FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency19
223FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency19
224FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency19
225WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
226WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
227WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
228RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency19
229RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency19
230RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency19
231TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency19
232TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency19
233TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency19
234NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer9
235NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer9
236NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer9
237RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency17
238LSTCHNUM SearchLast Check NumberCheck_NumberString20
239LSTCHKDT SearchLast Check DateDTDate8
240LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency17
241LSTINNUM SearchLast Invoice NumberSTR20String20
242LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency17
243LSTPURDT SearchLast Purchase DateDTDate8
244FSTPURDT SearchFirst Purchase DateDTDate8
245CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency17
246UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency17
247DYCHTCLR SearchDays Checks To ClearINT3_U0Integer3
248AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
249AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
250ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency17
251ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
252DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
253DOCFMTID SearchDocument Format IDSTR15_LBUString15
254DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
255GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
256GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
257PHONE3 SearchPhone 3Phone_Number3String14
258TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
259Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency19
260WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency19
261WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency19
262APLYWITH SearchApply WithholdingBooleanBoolean0
263CORRCTN SearchCorrectionCB_CorrectionBoolean0
264DocPrinted SearchDocPrintedCB_DocPrintedBoolean0

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
265ECTRX SearchEC TransactionCB_EC_TransactionBoolean0
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
266Electronic SearchElectronicCB_ElectronicBoolean0
267PRCHDATE SearchPurchase DateDTDate8
268SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
269TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean0
270BNKRCAMT SearchBank Receipts AmountDLR17_RBS0_STR$Currency17
271CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
272PMWRKMS2 SearchPM WORK Messages 2ML_PM_WORK_Messages_2Long Integer0
273VCHRNCOR SearchVoucher Number CorrectedSTR20_LBAUString20
274VNDCHKNM1 SearchASI_Vendor_Check_NameSTR64_Vendor_NameString64
275VADDCDPR1 SearchASI_Vendor_Address_Code_PrimarySTR15_Address_CodeString15
276PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString20
277SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString15
278TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString15
279CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString15
280HOLD1 SearchASI_HoldCB_HoldBoolean0
281PPSTAXRT1 SearchASI_PPS_Tax_RateINT5_%2Integer5
282NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
283CHEKBKID1 SearchASI_Checkbook_IDSTR15_Checkbook_IDString15
284MODIFDT1 SearchASI_Modified_DateDTDate8
285CREATDDT1 SearchASI_Created_DateDTDate8
286RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString15
287TaxInvRecvd1 SearchASI_Tax_Invoice_ReceivedCB_Tax_Invoice_ReceivedBoolean0
288VADCDTRO1 SearchASI_Vendor_Address_Code_Remit_ToSTR15_Address_CodeString15
azurecurveProductsSmartList (1493)PathnameSmartList Payables Transactions (ASIEXP09)

Leave a Reply

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