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:

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_ByLong IntegerLI_1414
2CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 NameStringSTR64_Customer_Name64
4ASI_Document_Status SearchASI_Document_StatusIntegerINT0
5CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
6DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
7CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
8BACHNUMB SearchBatch NumberStringSTR15_LBAU15
9BCHSOURC SearchBatch SourceStringSTR1515
10TRXSORCE SearchTRX SourceStringSTR1313
11CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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-AllIntegerINT22
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 TypeIntegerGB0
14DUEDATE SearchDue DateDateDT8
15DOCDATE SearchDocument DateDateDT8
16SYSPSTDT SearchSystem Posted DateDateDT_Date6
17POSTDATE SearchPost DateDateDT_Date6
18PSTUSRID SearchPost User IDStringSTR1515
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 DateDateDT_Date6
20LSTUSRED SearchLast User to EditStringSTR1515
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 AmountCurrencyDLR17_RBS0_STR$17
22CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
23SLSAMNT SearchSales AmountCurrencyDLR19_RBSO_UTR$19
24COSTAMNT SearchCost AmountCurrencyDLR19_RBSO_UTR$19
25FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
26MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
27TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
28COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
29CASHAMNT SearchCash AmountCurrencyDLR19_RBS0_UTR$19
30DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
31DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
32DISCDATE SearchDiscount DateDateDT8
33WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
34TRXDSCRN SearchTransaction DescriptionStringSTR3030
35CSPORNBR SearchCustomer Purchase Order NumberStringDocument_Number20
36SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
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 CodeStringSTR1515
38DINVPDOF SearchDate Invoice Paid OffDateDT8
39PPSAMDED SearchPPS Amount DeductedCurrencyDLR17_RBS0_UTR$17
40GSTDSAMT SearchGST Discount AmountCurrencyDLR17_RBS0_STR$17
41DELETE1 SearchDeleteBooleanYN0
42AGNGBUKT SearchAging BucketIntegerINT1_U01
43VOIDED SearchVoidedBooleanCB0
44DOCABREV SearchDocument AbbreviationStringSTR33
45DSCRIPTN SearchDescriptionStringSTR3030
46VOIDSTTS SearchVoid StatusIntegerINT0
47TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
48GLPOSTDT SearchGL Posting DateDateDT8
49CURRNIDX SearchCurrency IndexIntegerINT33
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 RateCurrency (Variable)DLR14_Exchange_Rate14
51ORCTRXAM SearchOriginating Current Trx AmountCurrencyDLR17_RBS0_UTR$17
52ORSLSAMT SearchOriginating Sales AmountCurrencyDLR19_RBSO_STR$19
53ORCSTAMT SearchOriginating Cost AmountCurrencyDLR19_RBSO_UTR$19
54ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
55ORMISCAMT SearchOriginating Misc AmountCurrencyDLR19_RBSO_UTR$19
56ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
57ORCASAMT SearchOriginating Cash AmountCurrencyDLR19_RBSO_UTR$19
58ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
59ORDAVAMT SearchOriginating Discount Available AmountCurrencyDLR17_RBS0_UTR$17
60ORDATKN SearchOriginating Discount Available TakenCurrencyDLR17_RBS0_UTR$17
61ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
62ORORGTRX SearchOriginating Original Trx AmountCurrencyDLR17_RBS0_STR$17
63ORWROFAM SearchOriginating Write Off AmountCurrencyDLR17_RBS0_STR$17
64AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
65AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
66AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
67AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
68AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
69AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
70AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
71DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
72MCTRXSTT SearchMC Transaction StateIntegerINT11
73Aging_Period_Amount SearchAging Period AmountCurrencyDLR19_$S219
74RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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 CashStringSTR15_Checkbook_ID15
76CBKIDCHK SearchCheckbook ID CheckStringSTR15_Checkbook_ID15
77CBKIDCRD SearchCheckbook ID Credit CardStringSTR15_Checkbook_ID15
78DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
79DISCRTND SearchDiscount ReturnedCurrencyDLR17_RBS0_STR$17
80DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
81DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
82VOIDDATE SearchVoid DateDateDT8
83TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 IDStringSTR20_Payment_Terms_ID20
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 MethodStringSTR15_Shipping_Method15
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 IDStringSTR15_LBU15
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 IDStringSTR15_LBAU15
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 IDStringSTR15_LBAU15
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 CodeStringSTR15_Address_Code15
90DOCPRFIX SearchDocument PrefixStringSTR33
91DOCDESCR SearchDocument DescriptionStringSTR3030
92POSTEDDT SearchPosted DateDateDATE6
93PTDUSRID SearchPosted User IDStringSTR1515
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 ToIntegerGB0
95NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
96SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
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 NumberStringSTR20_Document_Number20
98BKTSLSAM SearchBackout Sales AmountCurrencyDLR19_RBS0_UTR$19
99BKTFRTAM SearchBackout Freight AmountCurrencyDLR19_RBS0_UTR$19
100BKTMSCAM SearchBackout Misc AmountCurrencyDLR19_RBS0_UTR$19
101TXENGCLD SearchTax Engine CalledBooleanYN0
102DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
103APPLDAMT SearchApplied AmountCurrencyDLR17_RBS0_STR$17
104CASHDATE SearchCash DateDateDATE6
105DCNUMCSH SearchDocument Number CashStringSTR20_Document_Number20
106CHEKAMNT SearchCheck AmountCurrencyDLR19_RBS0_UTR$19
107CHEKDATE SearchCheck DateDateDATE6
108DCNUMCHK SearchDocument Number CheckStringSTR20_Document_Number20
109CRCRDAMT SearchCredit Card AmountCurrencyDLR19_RBS0_UTR$19
110CRCRDNAM SearchCredit Card NameStringSTR1515
111RCTNCCRD SearchReceipt Number Credit CardStringSTR20_Document_Number20
112CRCARDDT SearchCredit Card DateDateDATE6
113DCNUMCRD SearchDocument Number Credit CardStringSTR20_Document_Number20
114ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
115TRDDISCT SearchTrade DiscountIntegerINT4_%24
116NOTEINDX SearchNote IndexCurrencyDLR1414
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_SequenceLong IntegerASI_LI_10_RU10
118POSTED SearchPostedBooleanTrue/False0
119Tax_Date SearchTax DateDateDT8
120APLYWITH SearchApply WithholdingBooleanBoolean0
121SALEDATE SearchSale DateDateDT8
122CORRCTN SearchCorrectionBooleanCB_Correction0
123SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
124BALFWDNM SearchBalance Forward NumberStringSTR20_Document_Number20
125RMTREMSG SearchRM TRX Posting Error MessagesLong IntegerRM_TRX_Posting_Error_Messages0
126RMDPEMSG SearchRM Dist Posting Error MessagesLong IntegerRM_Dist_Posting_Error_Messages0
127EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
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 DateDateDT_Date6
129TIME1 SearchTimeTimeTM66
130RTCLCMTD SearchRate Calculation MethodIntegerGB0
131ORCHKAMT SearchOriginating Check AmountCurrencyDLR19_RBSO_UTR$19
132ORCCDAMT SearchOriginating Credit Card AmountCurrencyDLR19_RBSO_UTR$19
133ORAPPAMT SearchOriginating Applied AmountCurrencyDLR17_RBS0_STR$17
134ORDISRTD SearchOriginating Discount ReturnedCurrencyDLR17_RBS0_STR$17
135ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
136ORCOMAMT SearchOriginating Commission Dollar AmountCurrencyDLR17_RBSO_STR$17
137ORBKTSLS SearchOriginating Backout Sales AmountCurrencyDLR19_RBS0_UTR$19
138ORBKTFRT SearchOriginating Backout Freight AmountCurrencyDLR19_RBS0_UTR$19
139ORBKTMSC SearchOriginating Backout Misc AmountCurrencyDLR19_RBS0_UTR$19
140UNGANLOS SearchUnrealized Gain-Loss AmountCurrencyDLR19_$S219
141RMMCERRS SearchRM MC Posting Error MessagesLong IntegerRM_MC_Posting_Error_Messages0
142CUSTCLAS SearchCustomer ClassStringSTR15_Customer_Class15
143CNTCPRSN SearchContact PersonStringSTR6060
144STMTNAME SearchStatement NameStringSTR6464
145SHRTNAME SearchShort NameStringSTR1515
146UPSZONE SearchUPS ZoneStringSTR33
147ADDRESS1 SearchAddress 1StringSTR6060
148ADDRESS2 SearchAddress 2StringSTR6060
149ADDRESS3 SearchAddress 3StringSTR6060
150COUNTRY SearchCountryStringSTR6060
151CITY SearchCityStringSTR3535
152STATE SearchStateStringSTR30_State29
153ZIP SearchZipStringSTR1010
154PHONE1 SearchPhone 1StringPhone_Number14
155PHONE2 SearchPhone 2StringPhone_Number14
156PHONE3 SearchPhone 3StringPhone_Number314
157FAX SearchFaxStringSTR14_FAX14
158PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
159PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
160STADDRCD SearchStatement Address CodeStringSTR15_LBAU15
161CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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 TypeIntegerGB_Amt_Type0
163CRLMTAMT SearchCredit Limit AmountCurrencyDLR17_RBS0_UTR$17
164CRLMTPER SearchCredit Limit PeriodIntegerDDL0
165CRLMTPAM SearchCredit Limit Period AmountCurrencyDLR17_RBS0_UTR$17
166CUSTDISC SearchCustomer DiscountIntegerINT5_%25
167PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
168MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
169MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
170MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
171FNCHPCNT SearchFinance Charge PercentIntegerINT5_%25
172FINCHDLR SearchFinance Charge DollarCurrencyDLR17_RBS0_UTR$17
173FNCHATYP SearchFinance Charge Amt TypeIntegerGB_Amt_Type0
174MXWOFTYP SearchMaximum Writeoff TypeIntegerGP_Max_Writeoff0
175MXWROFAM SearchMax Writeoff AmountCurrencyDLR17_RBS0_UTR$17
176COMMENT1 SearchComment1StringSTR3030
177COMMENT2 SearchComment2StringSTR3030
178USERDEF1 SearchUser Defined 1StringSTR2020
179USERDEF2 SearchUser Defined 2StringSTR2020
180TAXEXMT1 SearchTax Exempt 1StringSTR2525
181TAXEXMT2 SearchTax Exempt 2StringSTR2525
182TXRGNNUM SearchTax Registration NumberStringSTR2525
183BALNCTYP SearchBalance TypeIntegerGB_Bal_Type0
184STMTCYCL SearchStatement CycleIntegerDDL_Stmt_Cycle0
185BANKNAME SearchBank NameStringSTR3030
186BNKBRNCH SearchBank BranchStringSTR2020
187DEFCACTY SearchDefault Cash Account TypeIntegerGB0
188RMCSHACC SearchRM Cash Account IndexLong IntegerLI_1414
189RMARACC SearchRM AR Account IndexLong IntegerLI_1414
190RMSLSACC SearchRM Sales Account IndexLong IntegerLI_1414
191RMIVACC SearchRM IV Account IndexLong IntegerLI_1414
192RMCOSACC SearchRM Cost Of Sales Account IndexLong IntegerLI_1414
193RMTAKACC SearchRM Discounts Taken Account IndexLong IntegerLI_1414
194RMAVACC SearchRM Discounts Avail Account IndexLong IntegerLI_1414
195RMFCGACC SearchRM Finance Charge Account IndexLong IntegerLI_1414
196RMWRACC SearchRM Writeoff Account IndexLong IntegerLI_1414
197FRSTINDT SearchFirst Invoice DateDateDT_Date6
198INACTIVE SearchInactiveBooleanCB_Inactive0
199HOLD SearchHoldBooleanCB_Hold0
200CRCARDID SearchCredit Card IDStringSTR1515
201CRCRDNUM SearchCredit Card NumberStringSTR2020
202CCRDXPDT SearchCredit Card Exp DateDateDT_Date6
203KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
204KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
205KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
206KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
207Revalue_Customer SearchRevalue CustomerBooleanCB Revalue Customer0
208Post_Results_To SearchPost Results ToIntegerGB0
209FINCHID SearchFinance Charge IDStringSTR15_Charge_ID15
210GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
211GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
212TNSFCLIF SearchTotal Amount Of NSF Checks LifeCurrencyDLR19_RBS0_STR$19
213NONSFLIF SearchNumber Of NSF Checks LifeLong IntegerLI6_U06
214CUSTBLNC SearchCustomer BalanceCurrencyDLR19_RBS0_STR$19
215LASTAGED SearchLast AgedDateDATE6
216LSTNSFCD SearchLast NSF Check DateDateDT_Date6
217LPYMTAMT SearchLast Payment AmountCurrencyDLR17_RBS0_STR$17
218LASTPYDT SearchLast Payment DateDateDT_Date6
219LSTTRXDT SearchLast Transaction DateDateDT_Date6
220LSTTRXAM SearchLast Transaction AmountCurrencyDLR17_RBS0_STR$17
221LSTFCHAM SearchLast Finance Charge AmountCurrencyDLR19_RBS0_STR$19
222UPFCHYTD SearchUnpaid Finance Charges YTDCurrencyDLR17_RBS0_UTR$17
223AVDTPLIF SearchAverage Days To Pay - LifeIntegerINT3_U03
224AVDTPLYR SearchAverage Days to Pay - LYRIntegerINT3_U03
225AVGDTPYR SearchAverage Days To Pay - YearIntegerINT3_U03
226NUMADTPL SearchNumber ADTP Documents - LifeLong IntegerLong_10U10
227NUMADTPR SearchNumber ADTP Documents - LYRLong IntegerLong_10U10
228NUMADTPY SearchNumber ADTP Documents - YearLong IntegerLong_10U10
229TDTKNLTD SearchTotal Discounts Taken LTDCurrencyDLR19_RBS0_STR$19
230TDTKNLYR SearchTotal Discounts Taken LYRCurrencyDLR19_RBS0_STR$19
231TDTKNYTD SearchTotal Discounts Taken YTDCurrencyDLR19_RBS0_STR$19
232TDISAYTD SearchTotal Discounts Available YTDCurrencyDLR19_RBS0_STR$19
233RETAINAG SearchRetainageCurrencyDLR19_RBS0_STR$19
234TNSFCYTD SearchTotal Amount Of NSF Checks YTDCurrencyDLR19_RBS0_STR$19
235NONSFYTD SearchNumber Of NSF Checks YTDLong IntegerLI6_U06
236UNPSTDSA SearchUnposted Sales AmountCurrencyDLR19_RBS0_UTR$19
237UNPSTDCA SearchUnposted Cash AmountCurrencyDLR19_RBS0_UTR$19
238UNPSTOCA SearchUnposted Other Cash AmountCurrencyDLR19_RBS0_UTR$19
239UNPSTOSA SearchUnposted Other Sales AmountCurrencyDLR19_RBS0_UTR$19
240NCSCHPMT SearchNon Current Scheduled PaymentsCurrencyDLR19_RBS0_STR$19
241TTLSLLTD SearchTotal Sales LTDCurrencyDLR19_RBS0_STR$19
242TTLSLLYR SearchTotal Sales LYRCurrencyDLR19_RBS0_STR$19
243TTLSLYTD SearchTotal Sales YTDCurrencyDLR19_RBS0_STR$19
244TCOSTLTD SearchTotal Costs LTDCurrencyDLR19_RBS0_STR$19
245TCOSTLYR SearchTotal Costs LYRCurrencyDLR19_RBS0_STR$19
246TCOSTYTD SearchTotal Costs YTDCurrencyDLR19_RBS0_STR$19
247TCSHRLTD SearchTotal Cash Received LTDCurrencyDLR19_RBS0_STR$19
248TCSHRLYR SearchTotal Cash Received LYRCurrencyDLR19_RBS0_STR$19
249TCSHRYTD SearchTotal Cash Received YTDCurrencyDLR19_RBS0_STR$19
250TFNCHLTD SearchTotal Finance Charges LTDCurrencyDLR19_RBS0_STR$19
251TFNCHLYR SearchTotal Finance Charges LYRCurrencyDLR19_RBS0_STR$19
252TFNCHYTD SearchTotal Finance Charges YTDCurrencyDLR19_RBS0_STR$19
253FNCHCYTD SearchFinance Charges CYTDCurrencyDLR19_RBS0_STR$19
254FNCHLYRC SearchFinance Charges LYR CalendarCurrencyDLR19_RBS0_STR$19
255TBDDTLYR SearchTotal Bad Deb LYRCurrencyDLR19_RBS0_STR$19
256TBDDTLTD SearchTotal Bad Debt LTDCurrencyDLR19_RBS0_STR$19
257TBDDTYTD SearchTotal Bad Debt YTDCurrencyDLR19_RBS0_STR$19
258TWVFCLTD SearchTotal Waived FC LTDCurrencyDLR19_RBS0_STR$19
259TWVFCLYR SearchTotal Waived FC LYRCurrencyDLR19_RBS0_STR$19
260TWVFCYTD SearchTotal Waived FC YTDCurrencyDLR19_RBS0_STR$19
261TWROFLTD SearchTotal Writeoffs LTDCurrencyDLR19_RBS0_STR$19
262TWROFLYR SearchTotal Writeoffs LYRCurrencyDLR19_RBS0_STR$19
263TWROFYTD SearchTotal Writeoffs YTDCurrencyDLR19_RBS0_STR$19
264TTLINLTD SearchTotal # Invoices LTDLong IntegerLI6_U06
265TTLINLYR SearchTotal # Invoices LYRLong IntegerLI6_U06
266TTLINYTD SearchTotal # Invoices YTDLong IntegerLI6_U06
267TTLFCLTD SearchTotal # FC LTDLong IntegerLI6_U06
268TTLFCLYR SearchTotal # FC LYRLong IntegerLI6_U06
269TTLFCYTD SearchTotal # FC YTDLong IntegerLI6_U06
270WROFSLIF SearchWrite Offs LIFECurrencyDLR19_RBS0_STR$19
271WROFSLYR SearchWrite Offs LYRCurrencyDLR19_RBS0_STR$19
272WROFSYTD SearchWrite Offs YTDCurrencyDLR19_RBS0_STR$19
273HIBALLTD SearchHigh Balance LTDCurrencyDLR19_RBSO_STR$19
274HIBALLYR SearchHigh Balance LYRCurrencyDLR19_RBSO_STR$19
275HIBALYTD SearchHigh Balance YTDCurrencyDLR19_RBSO_STR$19
276LASTSTDT SearchLast Statement DateDateDATE6
277LSTSTAMT SearchLast Statement AmountCurrencyDLR17_RBS0_STR$17
278DEPRECV SearchDeposits ReceivedCurrencyDLR19_RBS0_STR$19
279ONORDAMT SearchOn Order AmountCurrencyDLR19_RBS0_UTR$19
280DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
281DOCFMTID SearchDocument Format IDStringSTR15_LBU15
282DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
283ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
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 SearchElectronicBooleanCB_Electronic0
285CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
286DocPrinted SearchDocPrintedBooleanCB_DocPrinted0

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
287DOCNCORR SearchDocument Number CorrectedStringDocument_Number20
288PSTGSTUS SearchPosting StatusIntegerINT0
289RMTREMSG2 SearchRM TRX Posting Error Messages 2Long IntegerRM_TRX_Posting_Error_Messages_20
290CUSTNAME1 SearchASI_Customer_NameStringSTR64_Customer_Name64
291CPRCSTNM1 SearchASI_Corporate_Customer_NumberStringSTR15_RM_Customer_Number15
292ASI_Address_Code SearchASI_Address_CodeStringSTR15_Address_Code15
293SHIPMTHD1 SearchASI_Shipping_MethodStringSTR15_Shipping_Method15
294TAXSCHID1 SearchASI_Tax_Schedule_IDStringSTR15_Tax_Schedule_ID15
295SLPRSNID1 SearchASI_Salesperson_IDStringSTR15_Salesperson_ID15
296PYMTRMID1 SearchASI_Payment_Terms_IDStringSTR20_Payment_Terms_ID20
297CURNCYID1 SearchASI_Currency_IDStringSTR15_Currency_ID15
298RATETPID1 SearchASI_Rate_Type_IDStringSTR15_Rate_Type_ID15
299SALSTERR1 SearchASI_Sales_TerritoryStringSTR15_Sales_Territory15
300NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
301CREATDDT1 SearchASI_Created_DateDateDT8
302MODIFDT1 SearchASI_Modified_DateDateDT8
303DISGRPER1 SearchASI_Discount_Grace_PeriodIntegerINT2_U02
304DUEGRPER1 SearchASI_Due_Date_Grace_PeriodIntegerINT2_U02
305Factoring SearchFactoringBooleanboolean0
306ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultIntegerDDL_OrderFulfillDefault0
307CUSTPRIORITY SearchCustomer PriorityIntegerDDL_CustomerPriority0
azurecurveProductsSmartList (1493)PathnameSmartList Receivables Transaction (ASIEXP08)

Leave a Reply

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