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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3BCHSOURC SearchBatch SourceSTR15String1615
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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_NumberString2220
6DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
7ASI_Document_Status SearchASI_Document_StatusINTInteger20
8SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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$Currency1019
10DOCDATE SearchDocument DateDTDate48
11PSTGDATE SearchPosting DateDTDate48
12VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
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_IDString2220
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_IDString1615
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 DateDTDate48
16DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
17DISCDATE SearchDiscount DateDTDate48
18PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency1017
19CHRGAMNT SearchCharge AmountDLR19_RBSO_UTR$Currency1019
20CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency1019
21CAMCBKID SearchCash Amount Checkbook IDSTR15_Checkbook_IDString1615
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_NumberString2220
23CAMTDATE SearchCash Amount DateDTDate48
24CAMPMTNM SearchCash Amount Payment NumberSTR20_LBAUString2220
25CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019
26CHAMCBID SearchCheck Amount Checkbook IDSTR15_Checkbook_IDString1615
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 DateDATEDate46
28CAMPYNBR SearchCheck Amount Payment NumberSTR20_LBAUString2220
29CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency1019
30CCAMPYNM SearchCredit Card Amount Payment NumberSTR20_LBAUString2220
31CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
32CARDNAME SearchCard NameSTR15_Card_NameString1615
33CCRCTNUM SearchCredit Card Receipt NumberSTR20_Document_NumberString2220
34CRCARDDT SearchCredit Card DateDATEDate46
35CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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_IDString1615
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 DescriptionSTR30String3230
38UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency1017
39TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
41FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
42TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
43MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
44PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
45SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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$Currency1017
47DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
48APDSTKAM SearchApplied Discount Taken AmountDLR17_RBS0_UTR$Currency1017
49WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
50CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
51TXENGCLD SearchTax Engine CalledYNBoolean20
52PMWRKMSG SearchPM WORK MessagesML_PM_WORK_MessagesLong Integer40
53PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer40
54GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
55PGRAMSBJ SearchPercent Of Gross Amount SubjectINT5_RBS2_U%Integer25
56PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
57PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
58POSTED SearchPostedTrue/FalseBoolean20
59APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
60VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
61CNTRLTYP SearchControl TypeINT1Integer21
62MODIFDT SearchModified DateDTDate48
63MDFUSRID SearchModified User IDSTR15String1615
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 DateDATEDate46
65PTDUSRID SearchPosted User IDSTR15String1615
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 IndexDLR14Currency1014
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$Currency1019
68BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
69BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
70PCHSCHID SearchPurchase Schedule IDSTR15_LBAUString1615
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_LBAUString1615
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_LBAUString1615
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 SearchPrintedCBBoolean20

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
74PRCTDISC SearchPercent DiscountINT5_%2Integer25
75RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
76ICTRX SearchIC TRXCB_IC_TRXBoolean20

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
77ICDISTS SearchICDistsBooleanBoolean20

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
78PMICMSGS SearchICMessagesML_IC_Post_MessagesLong Integer40
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 DateDTDate48
80DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency1017
81TRXSORCE SearchTRX SourceSTR13String1413
82VOIDED SearchVoidedCBBoolean20
83HOLD SearchHoldCB_HoldBoolean20
84DINVPDOF SearchDate Invoice Paid OffDTDate48
85PYENTTYP SearchPayment Entry TypeGBInteger20
86TTLPYMTS SearchTotal PaymentsDLR19_RBS0_UTR$Currency1019
87DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
88VOIDPDATE SearchVoid GL Posting DateDTDate48
89ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
90DCSTATUS SearchDocument StatusDDL_Doc_StatusInteger20
91PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
92CURRNIDX SearchCurrency IndexINT3Integer23
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_IDString1615
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_IDString1615
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)1014
96EXCHDATE SearchExchange DateDT_DateDate46
97TIME1 SearchTimeTM6Time46
98RTCLCMTD SearchRate Calculation MethodGBInteger20
99ORCTRXAM SearchOriginating Current Trx AmountDLR17_RBS0_UTR$Currency1017
100OPURAMT SearchOriginating Purchases AmountDLR17_RBS0_UTR$Currency1017
101ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
102OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency1017
103ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
104ORCASAMT SearchOriginating Cash AmountDLR19_RBSO_UTR$Currency1019
105ORCHKAMT SearchOriginating Check AmountDLR19_RBSO_UTR$Currency1019
106ORCHKTTL SearchOriginating Check TotalDLR19_RBS0_UTR$Currency1019
107ORCCDAMT SearchOriginating Credit Card AmountDLR19_RBSO_UTR$Currency1019
108ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency1017
109ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
110ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
111ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
112ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
113ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
114OBKPURAMT SearchOriginating Backout Purchases AmountDLR19_RBS0_UTR$Currency1019
115ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency1019
116ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency1019
117UNGANLOS SearchUnrealized Gain-Loss AmountDLR19_$S2Currency1019
118RMMCERRS SearchRM MC Posting Error MessagesRM_MC_Posting_Error_MessagesLong Integer40
119OCHGAMT SearchOriginating Charge AmountDLR19_RBSO_UTR$Currency1019
120ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency1017
121ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency1017
122ORGAPDISCTKN SearchOriginating Applied Discount Taken AmountDLR17_RBS0_UTR$Currency1017
123OTOTPAY SearchOriginating Total PaymentsDLR19_RBS0_UTR$Currency1019
124OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency1017
125DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
126MCTRXSTT SearchMC Transaction StateINT1Integer21
127VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
128VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
129VENDSHNM SearchVendor Short NameSTR15String1615
130VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
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_CodeString1615
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_CodeString1615
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_IDString1210
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 ContactSTR60String6260
135ADDRESS1 SearchAddress 1STR60String6260
136ADDRESS2 SearchAddress 2STR60String6260
137ADDRESS3 SearchAddress 3STR60String6260
138CITY SearchCitySTR35String3635
139STATE SearchStateSTR30_StateString3029
140ZIPCODE SearchZip CodeSTR10String1210
141COUNTRY SearchCountrySTR60String6260
142PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
143PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
144FAXNUMBR SearchFax NumberSTR14_FAXString2214
145UPSZONE SearchUPS ZoneSTR3String43
146ACNMVNDR SearchAccount Number With VendorSTR20String2220
147TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
148VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
149TXRGNNUM SearchTax Registration NumberSTR25String2625
150PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
151TRDDISCT SearchTrade DiscountINT4_%2Integer24
152TEN99TYPE Search1099 Type1099_TypeInteger20
153MINORDER SearchMinimum OrderDLR17_$U2Currency1017
154MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
155MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
156MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
157MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
158MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
159COMMENT1 SearchComment1STR30String3230
160COMMENT2 SearchComment2STR30String3230
161USERDEF1 SearchUser Defined 1STR20String2220
162USERDEF2 SearchUser Defined 2STR20String2220
163CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
164PYMNTPRI SearchPayment PrioritySTR3String43
165KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
166KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
167KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
168KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
169PTCSHACF SearchPost To Cash Account FromGBInteger20
170CREDTLMT SearchCredit LimitGBInteger20
171WRITEOFF SearchWriteoffGBInteger20
172MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
173SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
174DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
175CRTCOMDT SearchCertificate Commencing DateDTDate48
176CRTEXPDT SearchCertificate Expiration DateDTDate48
177RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
178XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
179PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
180PMAPINDX SearchPM AP IndexLI_14Long Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 VendorBoolean20
195Post_Results_To SearchPost Results ToGBInteger20
196FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
197HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency1017
198CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
199NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer49
200NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer49
201NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer49
202NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer49
203NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer49
204AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency1019
205AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency1019
206AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency1019
207AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency1019
208AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency1019
209AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency1019
210TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency1019
211TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency1019
212TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency1019
213DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency1019
214DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency1019
215DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency1019
216DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency1019
217DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency1019
218DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency1019
219DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency1019
220DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency1019
221DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency1019
222FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency1019
223FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency1019
224FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency1019
225WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
226WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
227WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
228RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency1019
229RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency1019
230RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency1019
231TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency1019
232TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency1019
233TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency1019
234NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer49
235NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer49
236NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer49
237RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency1017
238LSTCHNUM SearchLast Check NumberCheck_NumberString2220
239LSTCHKDT SearchLast Check DateDTDate48
240LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency1017
241LSTINNUM SearchLast Invoice NumberSTR20String2220
242LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency1017
243LSTPURDT SearchLast Purchase DateDTDate48
244FSTPURDT SearchFirst Purchase DateDTDate48
245CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency1017
246UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency1017
247DYCHTCLR SearchDays Checks To ClearINT3_U0Integer23
248AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
249AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
250ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency1017
251ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
252DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
253DOCFMTID SearchDocument Format IDSTR15_LBUString1615
254DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
255GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
256GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
257PHONE3 SearchPhone 3Phone_Number3String2214
258TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
259Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency1019
260WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency1019
261WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency1019
262APLYWITH SearchApply WithholdingBooleanBoolean20
263CORRCTN SearchCorrectionCB_CorrectionBoolean20
264DocPrinted SearchDocPrintedCB_DocPrintedBoolean20

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
265ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
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_ElectronicBoolean20
267PRCHDATE SearchPurchase DateDTDate48
268SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
269TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
270BNKRCAMT SearchBank Receipts AmountDLR17_RBS0_STR$Currency1017
271CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean20
272PMWRKMS2 SearchPM WORK Messages 2ML_PM_WORK_Messages_2Long Integer40
273VCHRNCOR SearchVoucher Number CorrectedSTR20_LBAUString2220
274VNDCHKNM1 SearchASI_Vendor_Check_NameSTR64_Vendor_NameString6664
275VADDCDPR1 SearchASI_Vendor_Address_Code_PrimarySTR15_Address_CodeString1615
276PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString2220
277SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString1615
278TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString1615
279CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString1615
280HOLD1 SearchASI_HoldCB_HoldBoolean20
281PPSTAXRT1 SearchASI_PPS_Tax_RateINT5_%2Integer25
282NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
283CHEKBKID1 SearchASI_Checkbook_IDSTR15_Checkbook_IDString1615
284MODIFDT1 SearchASI_Modified_DateDTDate48
285CREATDDT1 SearchASI_Created_DateDTDate48
286RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString1615
287TaxInvRecvd1 SearchASI_Tax_Invoice_ReceivedCB_Tax_Invoice_ReceivedBoolean20
288VADCDTRO1 SearchASI_Vendor_Address_Code_Remit_ToSTR15_Address_CodeString1615
azurecurveProductsSmartList (1493)PathnameSmartList Payables Transactions (ASIEXP09)

Leave a Reply

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