SmartList Receivables Transaction (ASIEXP08)

azurecurveProductsSmartList (1493)PathnameSmartList Receivables Transaction (ASIEXP08)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Receivables Transaction
Physical Name: ASIEXP08
Technical Name: ASI_RM_Document_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].CUSTNMBR AS 'SmartList Receivables Transaction-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList Receivables Transaction'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
4ASI_Document_Status SearchASI_Document_StatusINTInteger0
5CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
6DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
7CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
8BACHNUMB SearchBatch NumberSTR15_LBAUString15
9BCHSOURC SearchBatch SourceSTR15String15
10TRXSORCE SearchTRX SourceSTR13String13
11CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].CURNCYID AS 'SmartList Receivables Transaction-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Receivables Transaction'].CURNCYID = ['Currency Setup'].CURNCYID
12RMDTYPAL SearchRM Document Type-AllINT2Integer2
Document Type records the type of document.

Click to show/hide the Document Types


0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments
13CSHRCTYP SearchCash Receipt TypeGBInteger0
14DUEDATE SearchDue DateDTDate8
15DOCDATE SearchDocument DateDTDate8
16SYSPSTDT SearchSystem Posted DateDT_DateDate6
17POSTDATE SearchPost DateDT_DateDate6
18PSTUSRID SearchPost User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].PSTUSRID AS 'SmartList Receivables Transaction-Post User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Receivables Transaction'].PSTUSRID = ['Users Master'].USERID
19LSTEDTDT SearchLast Edit DateDT_DateDate6
20LSTUSRED SearchLast User to EditSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].LSTUSRED AS 'SmartList Receivables Transaction-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Receivables Transaction'].LSTUSRED = ['Users Master'].USERID
21ORTRXAMT SearchOriginal Trx AmountDLR17_RBS0_STR$Currency17
22CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency17
23SLSAMNT SearchSales AmountDLR19_RBSO_UTR$Currency19
24COSTAMNT SearchCost AmountDLR19_RBSO_UTR$Currency19
25FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
26MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
27TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
28COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency17
29CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency19
30DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
31DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
32DISCDATE SearchDiscount DateDTDate8
33WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
34TRXDSCRN SearchTransaction DescriptionSTR30String30
35CSPORNBR SearchCustomer Purchase Order NumberDocument_NumberString20
36SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].SLPRSNID AS 'SmartList Receivables Transaction-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SmartList Receivables Transaction'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
37SLSTERCD SearchSales Territory CodeSTR15String15
38DINVPDOF SearchDate Invoice Paid OffDTDate8
39PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency17
40GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency17
41DELETE1 SearchDeleteYNBoolean0
42AGNGBUKT SearchAging BucketINT1_U0Integer1
43VOIDED SearchVoidedCBBoolean0
44DOCABREV SearchDocument AbbreviationSTR3String3
45DSCRIPTN SearchDescriptionSTR30String30
46VOIDSTTS SearchVoid StatusINTInteger0
47TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
48GLPOSTDT SearchGL Posting DateDTDate8
49CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].CURRNIDX AS 'SmartList Receivables Transaction-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Receivables Transaction'].CURRNIDX = ['Currency Setup'].CURRNIDX
50XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
51ORCTRXAM SearchOriginating Current Trx AmountDLR17_RBS0_UTR$Currency17
52ORSLSAMT SearchOriginating Sales AmountDLR19_RBSO_STR$Currency19
53ORCSTAMT SearchOriginating Cost AmountDLR19_RBSO_UTR$Currency19
54ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
55ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
56ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
57ORCASAMT SearchOriginating Cash AmountDLR19_RBSO_UTR$Currency19
58ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
59ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
60ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
61ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
62ORORGTRX SearchOriginating Original Trx AmountDLR17_RBS0_STR$Currency17
63ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency17
64AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
65AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
66AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
67AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
68AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
69AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
70AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
71DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
72MCTRXSTT SearchMC Transaction StateINT1Integer1
73Aging_Period_Amount SearchAging Period AmountDLR19_$S2Currency19
74RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].RATETPID AS 'SmartList Receivables Transaction-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Receivables Transaction'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
75CBKIDCSH SearchCheckbook ID CashSTR15_Checkbook_IDString15
76CBKIDCHK SearchCheckbook ID CheckSTR15_Checkbook_IDString15
77CBKIDCRD SearchCheckbook ID Credit CardSTR15_Checkbook_IDString15
78DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
79DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency17
80DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
81DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
82VOIDDATE SearchVoid DateDTDate8
83TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].TAXSCHID AS 'SmartList Receivables Transaction-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Receivables Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
84PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].PYMTRMID AS 'SmartList Receivables Transaction-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Receivables Transaction'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
85SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].SHIPMTHD AS 'SmartList Receivables Transaction-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Receivables Transaction'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
86SLSCHDID SearchSales Schedule IDSTR15_LBUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].SLSCHDID AS 'SmartList Receivables Transaction-Sales Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Receivables Transaction'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
87FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].MSCSCHID AS 'SmartList Receivables Transaction-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Receivables Transaction'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
89ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
90DOCPRFIX SearchDocument PrefixSTR3String3
91DOCDESCR SearchDocument DescriptionSTR30String30
92POSTEDDT SearchPosted DateDATEDate6
93PTDUSRID SearchPosted User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].PTDUSRID AS 'SmartList Receivables Transaction-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Receivables Transaction'].PTDUSRID = ['Users Master'].USERID
94COMAPPTO SearchCommission Applied ToGBInteger0
95NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency19
96SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].SALSTERR AS 'SmartList Receivables Transaction-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['SmartList Receivables Transaction'].SALSTERR = ['Sales Territory Master File'].SALSTERR
97CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString20
98BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency19
99BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency19
100BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency19
101TXENGCLD SearchTax Engine CalledYNBoolean0
102DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
103APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency17
104CASHDATE SearchCash DateDATEDate6
105DCNUMCSH SearchDocument Number CashSTR20_Document_NumberString20
106CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency19
107CHEKDATE SearchCheck DateDATEDate6
108DCNUMCHK SearchDocument Number CheckSTR20_Document_NumberString20
109CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency19
110CRCRDNAM SearchCredit Card NameSTR15String15
111RCTNCCRD SearchReceipt Number Credit CardSTR20_Document_NumberString20
112CRCARDDT SearchCredit Card DateDATEDate6
113DCNUMCRD SearchDocument Number Credit CardSTR20_Document_NumberString20
114ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
115TRDDISCT SearchTrade DiscountINT4_%2Integer4
116NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].NOTEINDX AS 'SmartList Receivables Transaction-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Receivables Transaction'].NOTEINDX = ['Record Notes Master'].NOTEINDX
117ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
118POSTED SearchPostedTrue/FalseBoolean0
119Tax_Date SearchTax DateDTDate8
120APLYWITH SearchApply WithholdingBooleanBoolean0
121SALEDATE SearchSale DateDTDate8
122CORRCTN SearchCorrectionCB_CorrectionBoolean0
123SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
124BALFWDNM SearchBalance Forward NumberSTR20_Document_NumberString20
125RMTREMSG SearchRM TRX Posting Error MessagesRM_TRX_Posting_Error_MessagesLong Integer0
126RMDPEMSG SearchRM Dist Posting Error MessagesRM_Dist_Posting_Error_MessagesLong Integer0
127EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].EXGTBLID AS 'SmartList Receivables Transaction-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SmartList Receivables Transaction'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
128EXCHDATE SearchExchange DateDT_DateDate6
129TIME1 SearchTimeTM6Time6
130RTCLCMTD SearchRate Calculation MethodGBInteger0
131ORCHKAMT SearchOriginating Check AmountDLR19_RBSO_UTR$Currency19
132ORCCDAMT SearchOriginating Credit Card AmountDLR19_RBSO_UTR$Currency19
133ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency17
134ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency17
135ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
136ORCOMAMT SearchOriginating Commission Dollar AmountDLR17_RBSO_STR$Currency17
137ORBKTSLS SearchOriginating Backout Sales AmountDLR19_RBS0_UTR$Currency19
138ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency19
139ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency19
140UNGANLOS SearchUnrealized Gain-Loss AmountDLR19_$S2Currency19
141RMMCERRS SearchRM MC Posting Error MessagesRM_MC_Posting_Error_MessagesLong Integer0
142CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
143CNTCPRSN SearchContact PersonSTR60String60
144STMTNAME SearchStatement NameSTR64String64
145SHRTNAME SearchShort NameSTR15String15
146UPSZONE SearchUPS ZoneSTR3String3
147ADDRESS1 SearchAddress 1STR60String60
148ADDRESS2 SearchAddress 2STR60String60
149ADDRESS3 SearchAddress 3STR60String60
150COUNTRY SearchCountrySTR60String60
151CITY SearchCitySTR35String35
152STATE SearchStateSTR30_StateString29
153ZIP SearchZipSTR10String10
154PHONE1 SearchPhone 1Phone_NumberString14
155PHONE2 SearchPhone 2Phone_NumberString14
156PHONE3 SearchPhone 3Phone_Number3String14
157FAX SearchFaxSTR14_FAXString14
158PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
159PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
160STADDRCD SearchStatement Address CodeSTR15_LBAUString15
161CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Receivables Transaction'].CHEKBKID AS 'SmartList Receivables Transaction-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP08 AS ['SmartList Receivables Transaction']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Receivables Transaction'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
162CRLMTTYP SearchCredit Limit TypeGB_Amt_TypeInteger0
163CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
164CRLMTPER SearchCredit Limit PeriodDDLInteger0
165CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
166CUSTDISC SearchCustomer DiscountINT5_%2Integer5
167PRCLEVEL SearchPriceLevelSTR10_LBAUString10
168MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
169MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
170MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
171FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
172FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
173FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
174MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
175MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
176COMMENT1 SearchComment1STR30String30
177COMMENT2 SearchComment2STR30String30
178USERDEF1 SearchUser Defined 1STR20String20
179USERDEF2 SearchUser Defined 2STR20String20
180TAXEXMT1 SearchTax Exempt 1STR25String25
181TAXEXMT2 SearchTax Exempt 2STR25String25
182TXRGNNUM SearchTax Registration NumberSTR25String25
183BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
184STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
185BANKNAME SearchBank NameSTR30String30
186BNKBRNCH SearchBank BranchSTR20String20
187DEFCACTY SearchDefault Cash Account TypeGBInteger0
188RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
189RMARACC SearchRM AR Account IndexLI_14Long Integer14
190RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
191RMIVACC SearchRM IV Account IndexLI_14Long Integer14
192RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
193RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
194RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
195RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
196RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
197FRSTINDT SearchFirst Invoice DateDT_DateDate6
198INACTIVE SearchInactiveCB_InactiveBoolean0
199HOLD SearchHoldCB_HoldBoolean0
200CRCARDID SearchCredit Card IDSTR15String15
201CRCRDNUM SearchCredit Card NumberSTR20String20
202CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
203KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
204KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
205KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
206KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
207Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
208Post_Results_To SearchPost Results ToGBInteger0
209FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
210GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
211GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
212TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
213NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
214CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
215LASTAGED SearchLast AgedDATEDate6
216LSTNSFCD SearchLast NSF Check DateDT_DateDate6
217LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
218LASTPYDT SearchLast Payment DateDT_DateDate6
219LSTTRXDT SearchLast Transaction DateDT_DateDate6
220LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
221LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
222UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
223AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
224AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer3
225AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
226NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
227NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
228NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
229TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
230TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
231TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
232TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
233RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
234TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
235NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
236UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
237UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
238UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
239UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
240NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
241TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
242TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
243TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
244TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
245TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
246TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
247TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
248TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
249TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
250TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
251TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
252TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
253FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
254FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
255TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
256TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
257TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
258TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
259TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
260TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
261TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
262TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
263TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
264TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
265TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
266TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
267TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
268TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
269TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
270WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
271WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
272WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
273HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
274HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
275HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
276LASTSTDT SearchLast Statement DateDATEDate6
277LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
278DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
279ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
280DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
281DOCFMTID SearchDocument Format IDSTR15_LBUString15
282DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
283ECTRX 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.
284Electronic SearchElectronicCB_ElectronicBoolean0
285CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
286DocPrinted SearchDocPrintedCB_DocPrintedBoolean0

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
287DOCNCORR SearchDocument Number CorrectedDocument_NumberString20
288PSTGSTUS SearchPosting StatusINTInteger0
289RMTREMSG2 SearchRM TRX Posting Error Messages 2RM_TRX_Posting_Error_Messages_2Long Integer0
290CUSTNAME1 SearchASI_Customer_NameSTR64_Customer_NameString64
291CPRCSTNM1 SearchASI_Corporate_Customer_NumberSTR15_RM_Customer_NumberString15
292ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString15
293SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString15
294TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString15
295SLPRSNID1 SearchASI_Salesperson_IDSTR15_Salesperson_IDString15
296PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString20
297CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString15
298RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString15
299SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString15
300NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
301CREATDDT1 SearchASI_Created_DateDTDate8
302MODIFDT1 SearchASI_Modified_DateDTDate8
303DISGRPER1 SearchASI_Discount_Grace_PeriodINT2_U0Integer2
304DUEGRPER1 SearchASI_Due_Date_Grace_PeriodINT2_U0Integer2
305Factoring SearchFactoringbooleanBoolean0
306ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger0
307CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger0
azurecurveProductsSmartList (1493)PathnameSmartList Receivables Transaction (ASIEXP08)

Leave a Reply

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