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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_NameString6664
4ASI_Document_Status SearchASI_Document_StatusINTInteger20
5CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
6DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
7CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
8BACHNUMB SearchBatch NumberSTR15_LBAUString1615
9BCHSOURC SearchBatch SourceSTR15String1615
10TRXSORCE SearchTRX SourceSTR13String1413
11CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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-AllINT2Integer22
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 TypeGBInteger20
14DUEDATE SearchDue DateDTDate48
15DOCDATE SearchDocument DateDTDate48
16SYSPSTDT SearchSystem Posted DateDT_DateDate46
17POSTDATE SearchPost DateDT_DateDate46
18PSTUSRID SearchPost User IDSTR15String1615
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_DateDate46
20LSTUSRED SearchLast User to EditSTR15String1615
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$Currency1017
22CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
23SLSAMNT SearchSales AmountDLR19_RBSO_UTR$Currency1019
24COSTAMNT SearchCost AmountDLR19_RBSO_UTR$Currency1019
25FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
26MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
27TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
28COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency1017
29CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency1019
30DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
31DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency1017
32DISCDATE SearchDiscount DateDTDate48
33WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
34TRXDSCRN SearchTransaction DescriptionSTR30String3230
35CSPORNBR SearchCustomer Purchase Order NumberDocument_NumberString2220
36SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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 CodeSTR15String1615
38DINVPDOF SearchDate Invoice Paid OffDTDate48
39PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
40GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
41DELETE1 SearchDeleteYNBoolean20
42AGNGBUKT SearchAging BucketINT1_U0Integer21
43VOIDED SearchVoidedCBBoolean20
44DOCABREV SearchDocument AbbreviationSTR3String43
45DSCRIPTN SearchDescriptionSTR30String3230
46VOIDSTTS SearchVoid StatusINTInteger20
47TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
48GLPOSTDT SearchGL Posting DateDTDate48
49CURRNIDX SearchCurrency IndexINT3Integer23
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)1014
51ORCTRXAM SearchOriginating Current Trx AmountDLR17_RBS0_UTR$Currency1017
52ORSLSAMT SearchOriginating Sales AmountDLR19_RBSO_STR$Currency1019
53ORCSTAMT SearchOriginating Cost AmountDLR19_RBSO_UTR$Currency1019
54ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
55ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency1019
56ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
57ORCASAMT SearchOriginating Cash AmountDLR19_RBSO_UTR$Currency1019
58ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
59ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency1017
60ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
61ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
62ORORGTRX SearchOriginating Original Trx AmountDLR17_RBS0_STR$Currency1017
63ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
64AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
65AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
66AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
67AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
68AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
69AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
70AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
71DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
72MCTRXSTT SearchMC Transaction StateINT1Integer21
73Aging_Period_Amount SearchAging Period AmountDLR19_$S2Currency1019
74RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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_IDString1615
76CBKIDCHK SearchCheckbook ID CheckSTR15_Checkbook_IDString1615
77CBKIDCRD SearchCheckbook ID Credit CardSTR15_Checkbook_IDString1615
78DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
79DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency1017
80DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
81DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
82VOIDDATE SearchVoid DateDTDate48
83TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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_IDString2220
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_MethodString1615
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_LBUString1615
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_LBAUString1615
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_LBAUString1615
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_CodeString1615
90DOCPRFIX SearchDocument PrefixSTR3String43
91DOCDESCR SearchDocument DescriptionSTR30String3230
92POSTEDDT SearchPosted DateDATEDate46
93PTDUSRID SearchPosted User IDSTR15String1615
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 ToGBInteger20
95NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency1019
96SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
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_NumberString2220
98BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency1019
99BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
100BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
101TXENGCLD SearchTax Engine CalledYNBoolean20
102DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
103APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
104CASHDATE SearchCash DateDATEDate46
105DCNUMCSH SearchDocument Number CashSTR20_Document_NumberString2220
106CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019
107CHEKDATE SearchCheck DateDATEDate46
108DCNUMCHK SearchDocument Number CheckSTR20_Document_NumberString2220
109CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency1019
110CRCRDNAM SearchCredit Card NameSTR15String1615
111RCTNCCRD SearchReceipt Number Credit CardSTR20_Document_NumberString2220
112CRCARDDT SearchCredit Card DateDATEDate46
113DCNUMCRD SearchDocument Number Credit CardSTR20_Document_NumberString2220
114ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency1019
115TRDDISCT SearchTrade DiscountINT4_%2Integer24
116NOTEINDX SearchNote IndexDLR14Currency1014
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 Integer410
118POSTED SearchPostedTrue/FalseBoolean20
119Tax_Date SearchTax DateDTDate48
120APLYWITH SearchApply WithholdingBooleanBoolean20
121SALEDATE SearchSale DateDTDate48
122CORRCTN SearchCorrectionCB_CorrectionBoolean20
123SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
124BALFWDNM SearchBalance Forward NumberSTR20_Document_NumberString2220
125RMTREMSG SearchRM TRX Posting Error MessagesRM_TRX_Posting_Error_MessagesLong Integer40
126RMDPEMSG SearchRM Dist Posting Error MessagesRM_Dist_Posting_Error_MessagesLong Integer40
127EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
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_DateDate46
129TIME1 SearchTimeTM6Time46
130RTCLCMTD SearchRate Calculation MethodGBInteger20
131ORCHKAMT SearchOriginating Check AmountDLR19_RBSO_UTR$Currency1019
132ORCCDAMT SearchOriginating Credit Card AmountDLR19_RBSO_UTR$Currency1019
133ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency1017
134ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency1017
135ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
136ORCOMAMT SearchOriginating Commission Dollar AmountDLR17_RBSO_STR$Currency1017
137ORBKTSLS SearchOriginating Backout Sales AmountDLR19_RBS0_UTR$Currency1019
138ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency1019
139ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency1019
140UNGANLOS SearchUnrealized Gain-Loss AmountDLR19_$S2Currency1019
141RMMCERRS SearchRM MC Posting Error MessagesRM_MC_Posting_Error_MessagesLong Integer40
142CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
143CNTCPRSN SearchContact PersonSTR60String6260
144STMTNAME SearchStatement NameSTR64String6664
145SHRTNAME SearchShort NameSTR15String1615
146UPSZONE SearchUPS ZoneSTR3String43
147ADDRESS1 SearchAddress 1STR60String6260
148ADDRESS2 SearchAddress 2STR60String6260
149ADDRESS3 SearchAddress 3STR60String6260
150COUNTRY SearchCountrySTR60String6260
151CITY SearchCitySTR35String3635
152STATE SearchStateSTR30_StateString3029
153ZIP SearchZipSTR10String1210
154PHONE1 SearchPhone 1Phone_NumberString2214
155PHONE2 SearchPhone 2Phone_NumberString2214
156PHONE3 SearchPhone 3Phone_Number3String2214
157FAX SearchFaxSTR14_FAXString2214
158PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
159PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
160STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
161CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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_TypeInteger20
163CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
164CRLMTPER SearchCredit Limit PeriodDDLInteger20
165CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
166CUSTDISC SearchCustomer DiscountINT5_%2Integer25
167PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
168MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
169MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
170MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
171FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
172FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
173FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
174MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
175MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
176COMMENT1 SearchComment1STR30String3230
177COMMENT2 SearchComment2STR30String3230
178USERDEF1 SearchUser Defined 1STR20String2220
179USERDEF2 SearchUser Defined 2STR20String2220
180TAXEXMT1 SearchTax Exempt 1STR25String2625
181TAXEXMT2 SearchTax Exempt 2STR25String2625
182TXRGNNUM SearchTax Registration NumberSTR25String2625
183BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
184STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
185BANKNAME SearchBank NameSTR30String3230
186BNKBRNCH SearchBank BranchSTR20String2220
187DEFCACTY SearchDefault Cash Account TypeGBInteger20
188RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
189RMARACC SearchRM AR Account IndexLI_14Long Integer414
190RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
191RMIVACC SearchRM IV Account IndexLI_14Long Integer414
192RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
193RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
194RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
195RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
196RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
197FRSTINDT SearchFirst Invoice DateDT_DateDate46
198INACTIVE SearchInactiveCB_InactiveBoolean20
199HOLD SearchHoldCB_HoldBoolean20
200CRCARDID SearchCredit Card IDSTR15String1615
201CRCRDNUM SearchCredit Card NumberSTR20String2220
202CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
203KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
204KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
205KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
206KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
207Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
208Post_Results_To SearchPost Results ToGBInteger20
209FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
210GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
211GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
212TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
213NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
214CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
215LASTAGED SearchLast AgedDATEDate46
216LSTNSFCD SearchLast NSF Check DateDT_DateDate46
217LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
218LASTPYDT SearchLast Payment DateDT_DateDate46
219LSTTRXDT SearchLast Transaction DateDT_DateDate46
220LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
221LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
222UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
223AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
224AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer23
225AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
226NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
227NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
228NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
229TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
230TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
231TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
232TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
233RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
234TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
235NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
236UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
237UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
238UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
239UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
240NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
241TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
242TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
243TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
244TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
245TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
246TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
247TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
248TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
249TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
250TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
251TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
252TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
253FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
254FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
255TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
256TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
257TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
258TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
259TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
260TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
261TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
262TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
263TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
264TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
265TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
266TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
267TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
268TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
269TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
270WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
271WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
272WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
273HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
274HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
275HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
276LASTSTDT SearchLast Statement DateDATEDate46
277LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
278DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
279ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
280DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
281DOCFMTID SearchDocument Format IDSTR15_LBUString1615
282DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
283ECTRX 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.
284Electronic SearchElectronicCB_ElectronicBoolean20
285CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean20
286DocPrinted SearchDocPrintedCB_DocPrintedBoolean20

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
287DOCNCORR SearchDocument Number CorrectedDocument_NumberString2220
288PSTGSTUS SearchPosting StatusINTInteger20
289RMTREMSG2 SearchRM TRX Posting Error Messages 2RM_TRX_Posting_Error_Messages_2Long Integer40
290CUSTNAME1 SearchASI_Customer_NameSTR64_Customer_NameString6664
291CPRCSTNM1 SearchASI_Corporate_Customer_NumberSTR15_RM_Customer_NumberString1615
292ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString1615
293SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString1615
294TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString1615
295SLPRSNID1 SearchASI_Salesperson_IDSTR15_Salesperson_IDString1615
296PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString2220
297CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString1615
298RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString1615
299SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString1615
300NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
301CREATDDT1 SearchASI_Created_DateDTDate48
302MODIFDT1 SearchASI_Modified_DateDTDate48
303DISGRPER1 SearchASI_Discount_Grace_PeriodINT2_U0Integer22
304DUEGRPER1 SearchASI_Due_Date_Grace_PeriodINT2_U0Integer22
305Factoring SearchFactoringbooleanBoolean20
306ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger20
307CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger20
azurecurveProductsSmartList (1493)PathnameSmartList Receivables Transaction (ASIEXP08)

Leave a Reply

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