SmartList Sales Transaction (ASIEXP06)

azurecurveProductsSmartList (1493)PathnameSmartList Sales Transaction (ASIEXP06)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Sales Transaction
Physical Name: ASIEXP06
Technical Name: ASI_SOP_HDR_MSTR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
3SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
4ASI_Document_Status SearchASI_Document_StatusINTInteger20
5ORIGTYPE SearchOriginal TypeDDL_SOP_TypeInteger20
6ORIGNUMB SearchOriginal NumberSTR20_SOP_NumberString2217
7DOCID SearchDocument IDSTR15_LBAUString1615
8DOCDATE SearchDocument DateDTDate48
9GLPOSTDT SearchGL Posting DateDTDate48
10QUOTEDAT SearchQuote DateDTDate48
11QUOEXPDA SearchQuote Expiration DateDTDate48
12ORDRDATE SearchOrder DateDTDate48
13INVODATE SearchInvoice DateDTDate48
14BACKDATE SearchBack Order DateDTDate48
15RETUDATE SearchReturn DateDTDate48
16ReqShipDate SearchRequested Ship DateDTDate48
17FUFILDAT SearchFulfillment DateDTDate48
18ACTLSHIP SearchActual Ship DateDTDate48
19DISCDATE SearchDiscount DateDTDate48
20DUEDATE SearchDue DateDTDate48
21REPTING SearchRepeatingCB_RepeatingBoolean20
22TRXFREQU SearchTRX FrequencyDDL_TRX_FrequencyInteger20
23TIMEREPD SearchTimes RepeatedINT4_U0Integer24
24TIMETREP SearchTimes To RepeatINT4_U0Integer24
25DYSTINCR SearchDays to IncrementINT3_RB0_UInteger23
26DTLSTREP SearchDate Last RepeatedDTDate48
27DSTBTCH1 SearchDest Batch 1STR15_LBAUString1615
28DSTBTCH2 SearchDest Batch 2STR15_LBAUString1615
29USDOCID1 SearchUse Document ID 1STR15_LBAUString1615
30USDOCID2 SearchUse Document ID 2STR15_LBAUString1615
31DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency1017
32ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency1017
33DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency1017
34ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency1017
35DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency1017
36ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency1017
37DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency1017
38ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency1017
39DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
40ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
41DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
42DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
43ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
44DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
45ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
46PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].PYMTRMID AS 'SmartList Sales Transaction-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Sales Transaction'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
47PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
48LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].LOCNCODE AS 'SmartList Sales Transaction-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Sales Transaction'].LOCNCODE = ['Site Setup'].LOCNCODE
49BCHSOURC SearchBatch SourceSTR15String1615
50BACHNUMB SearchBatch NumberSTR15_LBAUString1615
51CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].CUSTNMBR AS 'SmartList Sales Transaction-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList Sales Transaction'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
52CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
53CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString2220
54PROSPECT SearchProspectINT1Integer21
55MSTRNUMB SearchMaster NumberLI_MasterNumberLong Integer49
56PCKSLPNO SearchPacking Slip NumberSTR20_IVC_Document_NumberString2217
57PICTICNU SearchPicking Ticket NumberSTR20_SOP_NumberString2217
58MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
59ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency1017
60PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
61PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
62CNTCPRSN SearchContact PersonSTR60String6260
63ADDRESS1 SearchAddress 1STR60String6260
64ADDRESS2 SearchAddress 2STR60String6260
65ADDRESS3 SearchAddress 3STR60String6260
66CITY SearchCitySTR35String3635
67STATE SearchStateSTR30_StateString3029
68ZIPCODE SearchZip CodeSTR10String1210
69COUNTRY SearchCountrySTR60String6260
70PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
71PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
72FAXNUMBR SearchFax NumberSTR14_FAXString2214
73COMAPPTO SearchCommission Applied ToGBInteger20
74COMMAMNT SearchCommission AmountDLR17_RBS0_STR$Currency1017
75OCOMMAMT SearchOriginating Commission AmountDLR17_RBSO_STR$Currency1017
76CMMSLAMT SearchCommission Sale AmountDLR17_RBS0_STR$Currency1017
77ORCOSAMT SearchOriginating Commission Sales AmountDLR17_RBS0_STR$Currency1017
78NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency1019
79ORNCMAMT SearchOriginating Non-Commissioned AmountDLR19_RBS0_STR$Currency1019
80SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].SHIPMTHD AS 'SmartList Sales Transaction-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Sales Transaction'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
81TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
82ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
83TRDISPCT SearchTrade Discount PercentINT4_%2Integer24
84SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
85ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
86REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
87OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency1017
88EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
89OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
90FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
91ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
92MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
93ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency1019
94TXENGCLD SearchTax Engine CalledYNBoolean20
95TAXEXMT1 SearchTax Exempt 1STR25String2625
96TAXEXMT2 SearchTax Exempt 2STR25String2625
97TXRGNNUM SearchTax Registration NumberSTR25String2625
98TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].TAXSCHID AS 'SmartList Sales Transaction-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Sales Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
99TXSCHSRC SearchTax Schedule SourceINT1Integer21
100BSIVCTTL SearchBased On Invoice TotalYNBoolean20
101FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].FRTSCHID AS 'SmartList Sales Transaction-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Sales Transaction'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
102FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency1019
103ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
104FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger20
105MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].MSCSCHID AS 'SmartList Sales Transaction-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Sales Transaction'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
106MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
107ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
108MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger20
109BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
110ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency1019
111BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
112ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency1019
113BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
114OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
115TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency1019
116OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency1017
117TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
118ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
119ECTRX 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.
120DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
121ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency1017
122PYMTRCVD SearchPayment ReceivedDLR19_RBS0_UTR$Currency1019
123ORPMTRVD SearchOriginating Payment ReceivedDLR19_RBS0_UTR$Currency1019
124DEPRECVD SearchDeposit ReceivedDLR19_RBS0_UTR$Currency1019
125ORDEPRVD SearchOriginating Deposit ReceivedDLR19_RBS0_UTR$Currency1019
126CODAMNT SearchCOD AmountDLR17_RBS0_UTR$Currency1017
127ORCODAMT SearchOriginating COD AmountDLR17_RBS0_UTR$Currency1017
128ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency1019
129ORACTAMT SearchOriginating Account AmountDLR19_RBS0_UTR$Currency1019
130SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].SALSTERR AS 'SmartList Sales Transaction-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['SmartList Sales Transaction'].SALSTERR = ['Sales Territory Master File'].SALSTERR
131SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].SLPRSNID AS 'SmartList Sales Transaction-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SmartList Sales Transaction'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
132UPSZONE SearchUPS ZoneSTR3String43
133TIMESPRT SearchTimes PrintedINT4_U0Integer24
134PSTGSTUS SearchPosting StatusINTInteger20
135VOIDSTTS SearchVoid StatusINTInteger20
136ALLOCABY SearchAllocate ByDDL_Allocate_ByInteger20
137NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].NOTEINDX AS 'SmartList Sales Transaction-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Sales Transaction'].NOTEINDX = ['Record Notes Master'].NOTEINDX
138CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].CURNCYID AS 'SmartList Sales Transaction-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Sales Transaction'].CURNCYID = ['Currency Setup'].CURNCYID
139CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].CURRNIDX AS 'SmartList Sales Transaction-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Sales Transaction'].CURRNIDX = ['Currency Setup'].CURRNIDX
140RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].RATETPID AS 'SmartList Sales Transaction-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Sales Transaction'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
141EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].EXGTBLID AS 'SmartList Sales Transaction-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SmartList Sales Transaction'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
142XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
143EXCHDATE SearchExchange DateDT_DateDate46
144TIME1 SearchTimeTM6Time46
145RTCLCMTD SearchRate Calculation MethodGBInteger20
146TRXSORCE SearchTRX SourceSTR13String1413
147SOPHDRE1 SearchSOP HDR Errors 1ML_SOP_HDR_Errors_1Long Integer40
148SOPHDRE2 SearchSOP HDR Errors 2ML_SOP_HDR_Errors_2Long Integer40
149SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer40
150SOPHDRFL SearchSOP HDR FlagsML_SOP_HDR_FlagsLong Integer40
151SOPMCERR SearchSOP MC Posting Error MessagesSOP MC Posting Error MessagesLong Integer40
152COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].COMMNTID AS 'SmartList Sales Transaction-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['SmartList Sales Transaction'].COMMNTID = ['Comment Master'].COMMNTID
153REFRENCE SearchReferenceSTR30String3230
154POSTEDDT SearchPosted DateDATEDate46
155PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].PTDUSRID AS 'SmartList Sales Transaction-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Sales Transaction'].PTDUSRID = ['Users Master'].USERID
156USER2ENT SearchUser To EnterSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].USER2ENT AS 'SmartList Sales Transaction-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Sales Transaction'].USER2ENT = ['Users Master'].USERID
157CREATDDT SearchCreated DateDTDate48
158MODIFDT SearchModified DateDTDate48
159ShipToName SearchShipToNameSTR64_Customer_NameString6664
160MCTRXSTT SearchMC Transaction StateINT1Integer21
161DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
162Tax_Date SearchTax DateDTDate48
163ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
164CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
165CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
166STMTNAME SearchStatement NameSTR64String6664
167SHRTNAME SearchShort NameSTR15String1615
168STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
169CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Sales Transaction'].CHEKBKID AS 'SmartList Sales Transaction-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP06 AS ['SmartList Sales Transaction']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Sales Transaction'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
170CRLMTTYP SearchCredit Limit TypeGB_Amt_TypeInteger20
171CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
172CRLMTPER SearchCredit Limit PeriodDDLInteger20
173CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
174CUSTDISC SearchCustomer DiscountINT5_%2Integer25
175MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
176MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
177MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
178FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
179FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
180FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
181MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
182MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
183USERDEF1 SearchUser Defined 1STR20String2220
184USERDEF2 SearchUser Defined 2STR20String2220
185BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
186STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
187BANKNAME SearchBank NameSTR30String3230
188BNKBRNCH SearchBank BranchSTR20String2220
189DEFCACTY SearchDefault Cash Account TypeGBInteger20
190RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
191RMARACC SearchRM AR Account IndexLI_14Long Integer414
192RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
193RMIVACC SearchRM IV Account IndexLI_14Long Integer414
194RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
195RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
196RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
197RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
198RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
199FRSTINDT SearchFirst Invoice DateDT_DateDate46
200INACTIVE SearchInactiveCB_InactiveBoolean20
201HOLD SearchHoldCB_HoldBoolean20
202CRCARDID SearchCredit Card IDSTR15String1615
203CRCRDNUM SearchCredit Card NumberSTR20String2220
204CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
205KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
206KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
207KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
208KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
209Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
210Post_Results_To SearchPost Results ToGBInteger20
211FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
212GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
213GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
214UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
215TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
216NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
217CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
218AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
219AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
220AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
221AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
222AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
223AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
224AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
225LASTAGED SearchLast AgedDATEDate46
226LSTNSFCD SearchLast NSF Check DateDT_DateDate46
227LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
228LASTPYDT SearchLast Payment DateDT_DateDate46
229LSTTRXDT SearchLast Transaction DateDT_DateDate46
230LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
231LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
232UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
233AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer23
234AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
235AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
236NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
237NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
238NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
239TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
240TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
241TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
242TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
243RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
244TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
245NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
246UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
247UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
248UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
249NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
250TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
251TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
252TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
253TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
254TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
255TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
256TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
257TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
258TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
259TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
260TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
261TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
262FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
263FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
264TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
265TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
266TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
267TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
268TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
269TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
270TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
271TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
272TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
273TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
274TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
275TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
276TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
277TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
278TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
279WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
280WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
281WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
282HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
283HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
284HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
285LASTSTDT SearchLast Statement DateDATEDate46
286LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
287DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
288ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
289DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
290DOCFMTID SearchDocument Format IDSTR15_LBUString1615
291DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
292PHONE3 SearchPhone 3Phone_Number3String2214
293APLYWITH SearchApply WithholdingBooleanBoolean20
294CORRCTN SearchCorrectionCB_CorrectionBoolean20
295DOCNCORR SearchDocument Number CorrectedDocument_NumberString2220
296SALEDATE SearchSale DateDTDate48
297SEQNCORR SearchSequence Number CorrectedINTInteger20
298SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean20
299SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
300WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency1019
301CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean20
302SOPHDRE3 SearchSOP HDR Errors 3ML_SOP_HDR_Errors_3Long Integer40
303TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency1019
304TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency1019
305TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency1019
306CUSTNAME1 SearchASI_Customer_NameSTR64_Customer_NameString6664
307CNTCPRSN1 SearchASI_Contact_PersonSTR60String6260
308ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString1615
309UPSZONE1 SearchASI_UPS_ZoneSTR3String43
310SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString1615
311TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString1615
312ADDRESS11 SearchASI_Address_1STR60String6260
313ADDRESS21 SearchASI_Address_2STR60String6260
314ADDRESS31 SearchASI_Address_3STR60String6260
315COUNTRY1 SearchASI_CountrySTR60String6260
316CITY1 SearchASI_CitySTR35String3635
317STATE1 SearchASI_StateSTR30_StateString3029
318ZIP1 SearchASI_ZipSTR10String1210
319PHONE11 SearchASI_Phone_1Phone_NumberString2214
320PHONE21 SearchASI_Phone_2Phone_NumberString2214
321FAX1 SearchASI_FaxSTR14_FAXString2214
322PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString1615
323PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString1615
324SLPRSNID1 SearchASI_Salesperson_IDSTR15_Salesperson_IDString1615
325PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString2220
326CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString1615
327RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString1615
328PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString1210
329COMMENT11 SearchASI_Comment1STR30String3230
330COMMENT21 SearchASI_Comment2STR30String3230
331TAXEXMT11 SearchASI_Tax_Exempt_1STR25String2625
332TAXEXMT21 SearchASI_Tax_Exempt_2STR25String2625
333TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String2625
334SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString1615
335NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
336CREATDDT1 SearchASI_Created_DateDTDate48
337MODIFDT1 SearchASI_Modified_DateDTDate48
338PHONE31 SearchASI_Phone_3Phone_NumberString2214
339USERDEF11 SearchASI_User_Defined_1STR20String2220
340USERDEF21 SearchASI_User_Defined_2STR20String2220
341EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean20
342SOPSTATUS SearchSOP StatusINTInteger20
343CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger20
344ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger20
345SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean20
346SHIPCOMPLETE1 SearchASI_Ship_Complete_DocumentCB_ShipCompleteBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList Sales Transaction (ASIEXP06)

Leave a Reply

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