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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
3SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
4ASI_Document_Status SearchASI_Document_StatusINTInteger0
5ORIGTYPE SearchOriginal TypeDDL_SOP_TypeInteger0
6ORIGNUMB SearchOriginal NumberSTR20_SOP_NumberString17
7DOCID SearchDocument IDSTR15_LBAUString15
8DOCDATE SearchDocument DateDTDate8
9GLPOSTDT SearchGL Posting DateDTDate8
10QUOTEDAT SearchQuote DateDTDate8
11QUOEXPDA SearchQuote Expiration DateDTDate8
12ORDRDATE SearchOrder DateDTDate8
13INVODATE SearchInvoice DateDTDate8
14BACKDATE SearchBack Order DateDTDate8
15RETUDATE SearchReturn DateDTDate8
16ReqShipDate SearchRequested Ship DateDTDate8
17FUFILDAT SearchFulfillment DateDTDate8
18ACTLSHIP SearchActual Ship DateDTDate8
19DISCDATE SearchDiscount DateDTDate8
20DUEDATE SearchDue DateDTDate8
21REPTING SearchRepeatingCB_RepeatingBoolean0
22TRXFREQU SearchTRX FrequencyDDL_TRX_FrequencyInteger0
23TIMEREPD SearchTimes RepeatedINT4_U0Integer4
24TIMETREP SearchTimes To RepeatINT4_U0Integer4
25DYSTINCR SearchDays to IncrementINT3_RB0_UInteger3
26DTLSTREP SearchDate Last RepeatedDTDate8
27DSTBTCH1 SearchDest Batch 1STR15_LBAUString15
28DSTBTCH2 SearchDest Batch 2STR15_LBAUString15
29USDOCID1 SearchUse Document ID 1STR15_LBAUString15
30USDOCID2 SearchUse Document ID 2STR15_LBAUString15
31DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency17
32ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency17
33DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency17
34ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency17
35DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
36ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
37DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency17
38ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency17
39DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
40ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
41DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
42DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
43ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
44DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
45ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
46PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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_LBAUString10
48LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 SourceSTR15String15
50BACHNUMB SearchBatch NumberSTR15_LBAUString15
51CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NameString64
53CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString20
54PROSPECT SearchProspectINT1Integer1
55MSTRNUMB SearchMaster NumberLI_MasterNumberLong Integer9
56PCKSLPNO SearchPacking Slip NumberSTR20_IVC_Document_NumberString17
57PICTICNU SearchPicking Ticket NumberSTR20_SOP_NumberString17
58MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
59ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency17
60PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
61PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
62CNTCPRSN SearchContact PersonSTR60String60
63ADDRESS1 SearchAddress 1STR60String60
64ADDRESS2 SearchAddress 2STR60String60
65ADDRESS3 SearchAddress 3STR60String60
66CITY SearchCitySTR35String35
67STATE SearchStateSTR30_StateString29
68ZIPCODE SearchZip CodeSTR10String10
69COUNTRY SearchCountrySTR60String60
70PHNUMBR1 SearchPhone Number 1Phone_NumberString14
71PHNUMBR2 SearchPhone Number 2Phone_NumberString14
72FAXNUMBR SearchFax NumberSTR14_FAXString14
73COMAPPTO SearchCommission Applied ToGBInteger0
74COMMAMNT SearchCommission AmountDLR17_RBS0_STR$Currency17
75OCOMMAMT SearchOriginating Commission AmountDLR17_RBSO_STR$Currency17
76CMMSLAMT SearchCommission Sale AmountDLR17_RBS0_STR$Currency17
77ORCOSAMT SearchOriginating Commission Sales AmountDLR17_RBS0_STR$Currency17
78NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency19
79ORNCMAMT SearchOriginating Non-Commissioned AmountDLR19_RBS0_STR$Currency19
80SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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$Currency17
82ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
83TRDISPCT SearchTrade Discount PercentINT4_%2Integer4
84SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
85ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
86REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
87OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency17
88EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
89OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
90FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
91ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
92MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
93ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
94TXENGCLD SearchTax Engine CalledYNBoolean0
95TAXEXMT1 SearchTax Exempt 1STR25String25
96TAXEXMT2 SearchTax Exempt 2STR25String25
97TXRGNNUM SearchTax Registration NumberSTR25String25
98TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 SourceINT1Integer1
100BSIVCTTL SearchBased On Invoice TotalYNBoolean0
101FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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$Currency19
103ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
104FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger0
105MSCSCHID SearchMisc Schedule IDSTR15_LBAUString15
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$Currency19
107ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
108MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger0
109BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency19
110ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency19
111BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency19
112ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency19
113BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
114OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
115TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency19
116OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency17
117TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
118ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
119ECTRX 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.
120DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
121ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency17
122PYMTRCVD SearchPayment ReceivedDLR19_RBS0_UTR$Currency19
123ORPMTRVD SearchOriginating Payment ReceivedDLR19_RBS0_UTR$Currency19
124DEPRECVD SearchDeposit ReceivedDLR19_RBS0_UTR$Currency19
125ORDEPRVD SearchOriginating Deposit ReceivedDLR19_RBS0_UTR$Currency19
126CODAMNT SearchCOD AmountDLR17_RBS0_UTR$Currency17
127ORCODAMT SearchOriginating COD AmountDLR17_RBS0_UTR$Currency17
128ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
129ORACTAMT SearchOriginating Account AmountDLR19_RBS0_UTR$Currency19
130SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
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_IDString15
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 ZoneSTR3String3
133TIMESPRT SearchTimes PrintedINT4_U0Integer4
134PSTGSTUS SearchPosting StatusINTInteger0
135VOIDSTTS SearchVoid StatusINTInteger0
136ALLOCABY SearchAllocate ByDDL_Allocate_ByInteger0
137NOTEINDX SearchNote IndexDLR14Currency14
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_IDString15
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 IndexINT3Integer3
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_IDString15
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_IDString15
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)14
143EXCHDATE SearchExchange DateDT_DateDate6
144TIME1 SearchTimeTM6Time6
145RTCLCMTD SearchRate Calculation MethodGBInteger0
146TRXSORCE SearchTRX SourceSTR13String13
147SOPHDRE1 SearchSOP HDR Errors 1ML_SOP_HDR_Errors_1Long Integer0
148SOPHDRE2 SearchSOP HDR Errors 2ML_SOP_HDR_Errors_2Long Integer0
149SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer0
150SOPHDRFL SearchSOP HDR FlagsML_SOP_HDR_FlagsLong Integer0
151SOPMCERR SearchSOP MC Posting Error MessagesSOP MC Posting Error MessagesLong Integer0
152COMMNTID SearchComment IDSTR15_Comment_IDString15
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 SearchReferenceSTR30String30
154POSTEDDT SearchPosted DateDATEDate6
155PTDUSRID SearchPosted User IDSTR15String15
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_IDString15
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 DateDTDate8
158MODIFDT SearchModified DateDTDate8
159ShipToName SearchShipToNameSTR64_Customer_NameString64
160MCTRXSTT SearchMC Transaction StateINT1Integer1
161DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
162Tax_Date SearchTax DateDTDate8
163ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
164CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
165CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
166STMTNAME SearchStatement NameSTR64String64
167SHRTNAME SearchShort NameSTR15String15
168STADDRCD SearchStatement Address CodeSTR15_LBAUString15
169CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_TypeInteger0
171CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
172CRLMTPER SearchCredit Limit PeriodDDLInteger0
173CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
174CUSTDISC SearchCustomer DiscountINT5_%2Integer5
175MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
176MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
177MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
178FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
179FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
180FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
181MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
182MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
183USERDEF1 SearchUser Defined 1STR20String20
184USERDEF2 SearchUser Defined 2STR20String20
185BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
186STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
187BANKNAME SearchBank NameSTR30String30
188BNKBRNCH SearchBank BranchSTR20String20
189DEFCACTY SearchDefault Cash Account TypeGBInteger0
190RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
191RMARACC SearchRM AR Account IndexLI_14Long Integer14
192RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
193RMIVACC SearchRM IV Account IndexLI_14Long Integer14
194RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
195RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
196RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
197RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
198RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
199FRSTINDT SearchFirst Invoice DateDT_DateDate6
200INACTIVE SearchInactiveCB_InactiveBoolean0
201HOLD SearchHoldCB_HoldBoolean0
202CRCARDID SearchCredit Card IDSTR15String15
203CRCRDNUM SearchCredit Card NumberSTR20String20
204CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
205KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
206KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
207KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
208KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
209Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
210Post_Results_To SearchPost Results ToGBInteger0
211FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
212GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
213GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
214UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
215TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
216NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
217CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
218AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
219AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
220AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
221AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
222AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
223AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
224AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
225LASTAGED SearchLast AgedDATEDate6
226LSTNSFCD SearchLast NSF Check DateDT_DateDate6
227LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
228LASTPYDT SearchLast Payment DateDT_DateDate6
229LSTTRXDT SearchLast Transaction DateDT_DateDate6
230LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
231LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
232UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
233AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer3
234AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
235AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
236NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
237NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
238NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
239TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
240TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
241TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
242TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
243RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
244TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
245NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
246UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
247UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
248UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
249NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
250TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
251TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
252TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
253TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
254TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
255TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
256TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
257TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
258TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
259TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
260TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
261TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
262FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
263FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
264TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
265TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
266TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
267TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
268TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
269TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
270TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
271TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
272TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
273TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
274TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
275TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
276TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
277TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
278TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
279WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
280WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
281WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
282HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
283HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
284HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
285LASTSTDT SearchLast Statement DateDATEDate6
286LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
287DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
288ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
289DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
290DOCFMTID SearchDocument Format IDSTR15_LBUString15
291DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
292PHONE3 SearchPhone 3Phone_Number3String14
293APLYWITH SearchApply WithholdingBooleanBoolean0
294CORRCTN SearchCorrectionCB_CorrectionBoolean0
295DOCNCORR SearchDocument Number CorrectedDocument_NumberString20
296SALEDATE SearchSale DateDTDate8
297SEQNCORR SearchSequence Number CorrectedINTInteger0
298SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean0
299SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
300WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
301CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
302SOPHDRE3 SearchSOP HDR Errors 3ML_SOP_HDR_Errors_3Long Integer0
303TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency19
304TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency19
305TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency19
306CUSTNAME1 SearchASI_Customer_NameSTR64_Customer_NameString64
307CNTCPRSN1 SearchASI_Contact_PersonSTR60String60
308ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString15
309UPSZONE1 SearchASI_UPS_ZoneSTR3String3
310SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString15
311TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString15
312ADDRESS11 SearchASI_Address_1STR60String60
313ADDRESS21 SearchASI_Address_2STR60String60
314ADDRESS31 SearchASI_Address_3STR60String60
315COUNTRY1 SearchASI_CountrySTR60String60
316CITY1 SearchASI_CitySTR35String35
317STATE1 SearchASI_StateSTR30_StateString29
318ZIP1 SearchASI_ZipSTR10String10
319PHONE11 SearchASI_Phone_1Phone_NumberString14
320PHONE21 SearchASI_Phone_2Phone_NumberString14
321FAX1 SearchASI_FaxSTR14_FAXString14
322PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString15
323PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString15
324SLPRSNID1 SearchASI_Salesperson_IDSTR15_Salesperson_IDString15
325PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString20
326CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString15
327RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString15
328PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString10
329COMMENT11 SearchASI_Comment1STR30String30
330COMMENT21 SearchASI_Comment2STR30String30
331TAXEXMT11 SearchASI_Tax_Exempt_1STR25String25
332TAXEXMT21 SearchASI_Tax_Exempt_2STR25String25
333TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String25
334SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString15
335NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
336CREATDDT1 SearchASI_Created_DateDTDate8
337MODIFDT1 SearchASI_Modified_DateDTDate8
338PHONE31 SearchASI_Phone_3Phone_NumberString14
339USERDEF11 SearchASI_User_Defined_1STR20String20
340USERDEF21 SearchASI_User_Defined_2STR20String20
341EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean0
342SOPSTATUS SearchSOP StatusINTInteger0
343CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger0
344ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger0
345SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean0
346SHIPCOMPLETE1 SearchASI_Ship_Complete_DocumentCB_ShipCompleteBoolean0
azurecurveProductsSmartList (1493)PathnameSmartList Sales Transaction (ASIEXP06)

Leave a Reply

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