Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP08
Product: SmartList (1493)
Series:
Display Name: SmartList Receivables Transaction Group Display Name: SmartList Master
Physical Name: ASIEXP08
Technical Name: ASI_RM_Document_Explorer
Group Technical Name: ASI_Explorer_Logical_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ASI_Order_By ![]() | ASI_Order_By | Long Integer | LI_14 | 14 | |
2 | CUSTNMBR ![]() | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
3 | CUSTNAME ![]() | Customer Name | String | STR64_Customer_Name | 64 | |
4 | ASI_Document_Status ![]() | ASI_Document_Status | Integer | INT | 0 | |
5 | CPRCSTNM ![]() | Corporate Customer Number | String | STR15_RM_Customer_Number | 15 | |
6 | DOCNUMBR ![]() | Document Number | String | STR20_Document_Number | 20 | |
7 | CHEKNMBR ![]() | Check Number | String | STR20_Document_Number | 20 | |
8 | BACHNUMB ![]() | Batch Number | String | STR15_LBAU | 15 | |
9 | BCHSOURC ![]() | Batch Source | String | STR15 | 15 | |
10 | TRXSORCE ![]() | TRX Source | String | STR13 | 13 | |
11 | CURNCYID ![]() | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
12 | RMDTYPAL ![]() | RM Document Type-All | Integer | INT2 | 2 | |
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 | ||||||
13 | CSHRCTYP ![]() | Cash Receipt Type | Integer | GB | 0 | |
14 | DUEDATE ![]() | Due Date | Date | DT | 8 | |
15 | DOCDATE ![]() | Document Date | Date | DT | 8 | |
16 | SYSPSTDT ![]() | System Posted Date | Date | DT_Date | 6 | |
17 | POSTDATE ![]() | Post Date | Date | DT_Date | 6 | |
18 | PSTUSRID ![]() | Post User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
19 | LSTEDTDT ![]() | Last Edit Date | Date | DT_Date | 6 | |
20 | LSTUSRED ![]() | Last User to Edit | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
21 | ORTRXAMT ![]() | Original Trx Amount | Currency | DLR17_RBS0_STR$ | 17 | |
22 | CURTRXAM ![]() | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
23 | SLSAMNT ![]() | Sales Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
24 | COSTAMNT ![]() | Cost Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
25 | FRTAMNT ![]() | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
26 | MISCAMNT ![]() | Misc Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
27 | TAXAMNT ![]() | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
28 | COMDLRAM ![]() | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
29 | CASHAMNT ![]() | Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
30 | DISTKNAM ![]() | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
31 | DISAVAMT ![]() | Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
32 | DISCDATE ![]() | Discount Date | Date | DT | 8 | |
33 | WROFAMNT ![]() | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
34 | TRXDSCRN ![]() | Transaction Description | String | STR30 | 30 | |
35 | CSPORNBR ![]() | Customer Purchase Order Number | String | Document_Number | 20 | |
36 | SLPRSNID ![]() | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['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 | ||||||
37 | SLSTERCD ![]() | Sales Territory Code | String | STR15 | 15 | |
38 | DINVPDOF ![]() | Date Invoice Paid Off | Date | DT | 8 | |
39 | PPSAMDED ![]() | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
40 | GSTDSAMT ![]() | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
41 | DELETE1 ![]() | Delete | Boolean | YN | 0 | |
42 | AGNGBUKT ![]() | Aging Bucket | Integer | INT1_U0 | 1 | |
43 | VOIDED ![]() | Voided | Boolean | CB | 0 | |
44 | DOCABREV ![]() | Document Abbreviation | String | STR3 | 3 | |
45 | DSCRIPTN ![]() | Description | String | STR30 | 30 | |
46 | VOIDSTTS ![]() | Void Status | Integer | INT | 0 | |
47 | TRDISAMT ![]() | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
48 | GLPOSTDT ![]() | GL Posting Date | Date | DT | 8 | |
49 | CURRNIDX ![]() | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
50 | XCHGRATE ![]() | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
51 | ORCTRXAM ![]() | Originating Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
52 | ORSLSAMT ![]() | Originating Sales Amount | Currency | DLR19_RBSO_STR$ | 19 | |
53 | ORCSTAMT ![]() | Originating Cost Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
54 | ORFRTAMT ![]() | Originating Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
55 | ORMISCAMT ![]() | Originating Misc Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
56 | ORTAXAMT ![]() | Originating Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
57 | ORCASAMT ![]() | Originating Cash Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
58 | ORDISTKN ![]() | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
59 | ORDAVAMT ![]() | Originating Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
60 | ORDATKN ![]() | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
61 | ORTDISAM ![]() | Originating Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
62 | ORORGTRX ![]() | Originating Original Trx Amount | Currency | DLR17_RBS0_STR$ | 17 | |
63 | ORWROFAM ![]() | Originating Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
64 | AGPERAMT_1 ![]() | Aging Period Amounts[1] | Currency | DLR17_RBSO_STR$ | 17 | |
65 | AGPERAMT_2 ![]() | Aging Period Amounts[2] | Currency | DLR17_RBSO_STR$ | 17 | |
66 | AGPERAMT_3 ![]() | Aging Period Amounts[3] | Currency | DLR17_RBSO_STR$ | 17 | |
67 | AGPERAMT_4 ![]() | Aging Period Amounts[4] | Currency | DLR17_RBSO_STR$ | 17 | |
68 | AGPERAMT_5 ![]() | Aging Period Amounts[5] | Currency | DLR17_RBSO_STR$ | 17 | |
69 | AGPERAMT_6 ![]() | Aging Period Amounts[6] | Currency | DLR17_RBSO_STR$ | 17 | |
70 | AGPERAMT_7 ![]() | Aging Period Amounts[7] | Currency | DLR17_RBSO_STR$ | 17 | |
71 | DENXRATE ![]() | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
72 | MCTRXSTT ![]() | MC Transaction State | Integer | INT1 | 1 | |
73 | Aging_Period_Amount ![]() | Aging Period Amount | Currency | DLR19_$S2 | 19 | |
74 | RATETPID ![]() | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['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 | ||||||
75 | CBKIDCSH ![]() | Checkbook ID Cash | String | STR15_Checkbook_ID | 15 | |
76 | CBKIDCHK ![]() | Checkbook ID Check | String | STR15_Checkbook_ID | 15 | |
77 | CBKIDCRD ![]() | Checkbook ID Credit Card | String | STR15_Checkbook_ID | 15 | |
78 | DISAVTKN ![]() | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
79 | DISCRTND ![]() | Discount Returned | Currency | DLR17_RBS0_STR$ | 17 | |
80 | DSCDLRAM ![]() | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
81 | DSCPCTAM ![]() | Discount Percent Amount | Integer | INT5_%2 | 5 | |
82 | VOIDDATE ![]() | Void Date | Date | DT | 8 | |
83 | TAXSCHID ![]() | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
84 | PYMTRMID ![]() | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['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 | ||||||
85 | SHIPMTHD ![]() | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['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 | ||||||
86 | SLSCHDID ![]() | Sales Schedule ID | String | STR15_LBU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
87 | FRTSCHID ![]() | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
88 | MSCSCHID ![]() | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
89 | ADRSCODE ![]() | Address Code | String | STR15_Address_Code | 15 | |
90 | DOCPRFIX ![]() | Document Prefix | String | STR3 | 3 | |
91 | DOCDESCR ![]() | Document Description | String | STR30 | 30 | |
92 | POSTEDDT ![]() | Posted Date | Date | DATE | 6 | |
93 | PTDUSRID ![]() | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
94 | COMAPPTO ![]() | Commission Applied To | Integer | GB | 0 | |
95 | NCOMAMNT ![]() | Non-Commissioned Amount | Currency | DLR19_RBS0_STR$ | 19 | |
96 | SALSTERR ![]() | Sales Territory | String | STR15_Sales_Territory | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['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 | ||||||
97 | CSTPONBR ![]() | Customer PO Number | String | STR20_Document_Number | 20 | |
98 | BKTSLSAM ![]() | Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
99 | BKTFRTAM ![]() | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
100 | BKTMSCAM ![]() | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
101 | TXENGCLD ![]() | Tax Engine Called | Boolean | YN | 0 | |
102 | DOCAMNT ![]() | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
103 | APPLDAMT ![]() | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
104 | CASHDATE ![]() | Cash Date | Date | DATE | 6 | |
105 | DCNUMCSH ![]() | Document Number Cash | String | STR20_Document_Number | 20 | |
106 | CHEKAMNT ![]() | Check Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
107 | CHEKDATE ![]() | Check Date | Date | DATE | 6 | |
108 | DCNUMCHK ![]() | Document Number Check | String | STR20_Document_Number | 20 | |
109 | CRCRDAMT ![]() | Credit Card Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
110 | CRCRDNAM ![]() | Credit Card Name | String | STR15 | 15 | |
111 | RCTNCCRD ![]() | Receipt Number Credit Card | String | STR20_Document_Number | 20 | |
112 | CRCARDDT ![]() | Credit Card Date | Date | DATE | 6 | |
113 | DCNUMCRD ![]() | Document Number Credit Card | String | STR20_Document_Number | 20 | |
114 | ACCTAMNT ![]() | Account Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
115 | TRDDISCT ![]() | Trade Discount | Integer | INT4_%2 | 4 | |
116 | NOTEINDX ![]() | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
117 | ASI_Favorite_Sequence ![]() | ASI_Favorite_Sequence | Long Integer | ASI_LI_10_RU | 10 | |
118 | POSTED ![]() | Posted | Boolean | True/False | 0 | |
119 | Tax_Date ![]() | Tax Date | Date | DT | 8 | |
120 | APLYWITH ![]() | Apply Withholding | Boolean | Boolean | 0 | |
121 | SALEDATE ![]() | Sale Date | Date | DT | 8 | |
122 | CORRCTN ![]() | Correction | Boolean | CB_Correction | 0 | |
123 | SIMPLIFD ![]() | Simplified | Boolean | CB_Simplified | 0 | |
124 | BALFWDNM ![]() | Balance Forward Number | String | STR20_Document_Number | 20 | |
125 | RMTREMSG ![]() | RM TRX Posting Error Messages | Long Integer | RM_TRX_Posting_Error_Messages | 0 | |
126 | RMDPEMSG ![]() | RM Dist Posting Error Messages | Long Integer | RM_Dist_Posting_Error_Messages | 0 | |
127 | EXGTBLID ![]() | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['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 | ||||||
128 | EXCHDATE ![]() | Exchange Date | Date | DT_Date | 6 | |
129 | TIME1 ![]() | Time | Time | TM6 | 6 | |
130 | RTCLCMTD ![]() | Rate Calculation Method | Integer | GB | 0 | |
131 | ORCHKAMT ![]() | Originating Check Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
132 | ORCCDAMT ![]() | Originating Credit Card Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
133 | ORAPPAMT ![]() | Originating Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
134 | ORDISRTD ![]() | Originating Discount Returned | Currency | DLR17_RBS0_STR$ | 17 | |
135 | ORDDLRAT ![]() | Originating Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
136 | ORCOMAMT ![]() | Originating Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
137 | ORBKTSLS ![]() | Originating Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
138 | ORBKTFRT ![]() | Originating Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
139 | ORBKTMSC ![]() | Originating Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
140 | UNGANLOS ![]() | Unrealized Gain-Loss Amount | Currency | DLR19_$S2 | 19 | |
141 | RMMCERRS ![]() | RM MC Posting Error Messages | Long Integer | RM_MC_Posting_Error_Messages | 0 | |
142 | CUSTCLAS ![]() | Customer Class | String | STR15_Customer_Class | 15 | |
143 | CNTCPRSN ![]() | Contact Person | String | STR60 | 60 | |
144 | STMTNAME ![]() | Statement Name | String | STR64 | 64 | |
145 | SHRTNAME ![]() | Short Name | String | STR15 | 15 | |
146 | UPSZONE ![]() | UPS Zone | String | STR3 | 3 | |
147 | ADDRESS1 ![]() | Address 1 | String | STR60 | 60 | |
148 | ADDRESS2 ![]() | Address 2 | String | STR60 | 60 | |
149 | ADDRESS3 ![]() | Address 3 | String | STR60 | 60 | |
150 | COUNTRY ![]() | Country | String | STR60 | 60 | |
151 | CITY ![]() | City | String | STR35 | 35 | |
152 | STATE ![]() | State | String | STR30_State | 29 | |
153 | ZIP ![]() | Zip | String | STR10 | 10 | |
154 | PHONE1 ![]() | Phone 1 | String | Phone_Number | 14 | |
155 | PHONE2 ![]() | Phone 2 | String | Phone_Number | 14 | |
156 | PHONE3 ![]() | Phone 3 | String | Phone_Number3 | 14 | |
157 | FAX ![]() | Fax | String | STR14_FAX | 14 | |
158 | PRBTADCD ![]() | Primary Billto Address Code | String | STR15_LBAU | 15 | |
159 | PRSTADCD ![]() | Primary Shipto Address Code | String | STR15_LBAU | 15 | |
160 | STADDRCD ![]() | Statement Address Code | String | STR15_LBAU | 15 | |
161 | CHEKBKID ![]() | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['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 | ||||||
162 | CRLMTTYP ![]() | Credit Limit Type | Integer | GB_Amt_Type | 0 | |
163 | CRLMTAMT ![]() | Credit Limit Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
164 | CRLMTPER ![]() | Credit Limit Period | Integer | DDL | 0 | |
165 | CRLMTPAM ![]() | Credit Limit Period Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
166 | CUSTDISC ![]() | Customer Discount | Integer | INT5_%2 | 5 | |
167 | PRCLEVEL ![]() | PriceLevel | String | STR10_LBAU | 10 | |
168 | MINPYTYP ![]() | Minimum Payment Type | Integer | GB_Amt_Type | 0 | |
169 | MINPYDLR ![]() | Minimum Payment Dollar | Currency | DLR17_RBS0_UTR$ | 17 | |
170 | MINPYPCT ![]() | Minimum Payment Percent | Integer | INT5_%2 | 5 | |
171 | FNCHPCNT ![]() | Finance Charge Percent | Integer | INT5_%2 | 5 | |
172 | FINCHDLR ![]() | Finance Charge Dollar | Currency | DLR17_RBS0_UTR$ | 17 | |
173 | FNCHATYP ![]() | Finance Charge Amt Type | Integer | GB_Amt_Type | 0 | |
174 | MXWOFTYP ![]() | Maximum Writeoff Type | Integer | GP_Max_Writeoff | 0 | |
175 | MXWROFAM ![]() | Max Writeoff Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
176 | COMMENT1 ![]() | Comment1 | String | STR30 | 30 | |
177 | COMMENT2 ![]() | Comment2 | String | STR30 | 30 | |
178 | USERDEF1 ![]() | User Defined 1 | String | STR20 | 20 | |
179 | USERDEF2 ![]() | User Defined 2 | String | STR20 | 20 | |
180 | TAXEXMT1 ![]() | Tax Exempt 1 | String | STR25 | 25 | |
181 | TAXEXMT2 ![]() | Tax Exempt 2 | String | STR25 | 25 | |
182 | TXRGNNUM ![]() | Tax Registration Number | String | STR25 | 25 | |
183 | BALNCTYP ![]() | Balance Type | Integer | GB_Bal_Type | 0 | |
184 | STMTCYCL ![]() | Statement Cycle | Integer | DDL_Stmt_Cycle | 0 | |
185 | BANKNAME ![]() | Bank Name | String | STR30 | 30 | |
186 | BNKBRNCH ![]() | Bank Branch | String | STR20 | 20 | |
187 | DEFCACTY ![]() | Default Cash Account Type | Integer | GB | 0 | |
188 | RMCSHACC ![]() | RM Cash Account Index | Long Integer | LI_14 | 14 | |
189 | RMARACC ![]() | RM AR Account Index | Long Integer | LI_14 | 14 | |
190 | RMSLSACC ![]() | RM Sales Account Index | Long Integer | LI_14 | 14 | |
191 | RMIVACC ![]() | RM IV Account Index | Long Integer | LI_14 | 14 | |
192 | RMCOSACC ![]() | RM Cost Of Sales Account Index | Long Integer | LI_14 | 14 | |
193 | RMTAKACC ![]() | RM Discounts Taken Account Index | Long Integer | LI_14 | 14 | |
194 | RMAVACC ![]() | RM Discounts Avail Account Index | Long Integer | LI_14 | 14 | |
195 | RMFCGACC ![]() | RM Finance Charge Account Index | Long Integer | LI_14 | 14 | |
196 | RMWRACC ![]() | RM Writeoff Account Index | Long Integer | LI_14 | 14 | |
197 | FRSTINDT ![]() | First Invoice Date | Date | DT_Date | 6 | |
198 | INACTIVE ![]() | Inactive | Boolean | CB_Inactive | 0 | |
199 | HOLD ![]() | Hold | Boolean | CB_Hold | 0 | |
200 | CRCARDID ![]() | Credit Card ID | String | STR15 | 15 | |
201 | CRCRDNUM ![]() | Credit Card Number | String | STR20 | 20 | |
202 | CCRDXPDT ![]() | Credit Card Exp Date | Date | DT_Date | 6 | |
203 | KPDSTHST ![]() | Keep Distribution History | Boolean | CB_Keep_Dist_History | 0 | |
204 | KPCALHST ![]() | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 | |
205 | KPERHIST ![]() | Keep Period History | Boolean | CB_Keep_Period_History | 0 | |
206 | KPTRXHST ![]() | Keep Trx History | Boolean | CB_Keep_Trx_History | 0 | |
207 | Revalue_Customer ![]() | Revalue Customer | Boolean | CB Revalue Customer | 0 | |
208 | Post_Results_To ![]() | Post Results To | Integer | GB | 0 | |
209 | FINCHID ![]() | Finance Charge ID | String | STR15_Charge_ID | 15 | |
210 | GOVCRPID ![]() | Governmental Corporate ID | String | STR30_Gov_Corp_ID | 30 | |
211 | GOVINDID ![]() | Governmental Individual ID | String | STR30_Gov_Indiv_ID | 30 | |
212 | TNSFCLIF ![]() | Total Amount Of NSF Checks Life | Currency | DLR19_RBS0_STR$ | 19 | |
213 | NONSFLIF ![]() | Number Of NSF Checks Life | Long Integer | LI6_U0 | 6 | |
214 | CUSTBLNC ![]() | Customer Balance | Currency | DLR19_RBS0_STR$ | 19 | |
215 | LASTAGED ![]() | Last Aged | Date | DATE | 6 | |
216 | LSTNSFCD ![]() | Last NSF Check Date | Date | DT_Date | 6 | |
217 | LPYMTAMT ![]() | Last Payment Amount | Currency | DLR17_RBS0_STR$ | 17 | |
218 | LASTPYDT ![]() | Last Payment Date | Date | DT_Date | 6 | |
219 | LSTTRXDT ![]() | Last Transaction Date | Date | DT_Date | 6 | |
220 | LSTTRXAM ![]() | Last Transaction Amount | Currency | DLR17_RBS0_STR$ | 17 | |
221 | LSTFCHAM ![]() | Last Finance Charge Amount | Currency | DLR19_RBS0_STR$ | 19 | |
222 | UPFCHYTD ![]() | Unpaid Finance Charges YTD | Currency | DLR17_RBS0_UTR$ | 17 | |
223 | AVDTPLIF ![]() | Average Days To Pay - Life | Integer | INT3_U0 | 3 | |
224 | AVDTPLYR ![]() | Average Days to Pay - LYR | Integer | INT3_U0 | 3 | |
225 | AVGDTPYR ![]() | Average Days To Pay - Year | Integer | INT3_U0 | 3 | |
226 | NUMADTPL ![]() | Number ADTP Documents - Life | Long Integer | Long_10U | 10 | |
227 | NUMADTPR ![]() | Number ADTP Documents - LYR | Long Integer | Long_10U | 10 | |
228 | NUMADTPY ![]() | Number ADTP Documents - Year | Long Integer | Long_10U | 10 | |
229 | TDTKNLTD ![]() | Total Discounts Taken LTD | Currency | DLR19_RBS0_STR$ | 19 | |
230 | TDTKNLYR ![]() | Total Discounts Taken LYR | Currency | DLR19_RBS0_STR$ | 19 | |
231 | TDTKNYTD ![]() | Total Discounts Taken YTD | Currency | DLR19_RBS0_STR$ | 19 | |
232 | TDISAYTD ![]() | Total Discounts Available YTD | Currency | DLR19_RBS0_STR$ | 19 | |
233 | RETAINAG ![]() | Retainage | Currency | DLR19_RBS0_STR$ | 19 | |
234 | TNSFCYTD ![]() | Total Amount Of NSF Checks YTD | Currency | DLR19_RBS0_STR$ | 19 | |
235 | NONSFYTD ![]() | Number Of NSF Checks YTD | Long Integer | LI6_U0 | 6 | |
236 | UNPSTDSA ![]() | Unposted Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
237 | UNPSTDCA ![]() | Unposted Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
238 | UNPSTOCA ![]() | Unposted Other Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
239 | UNPSTOSA ![]() | Unposted Other Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
240 | NCSCHPMT ![]() | Non Current Scheduled Payments | Currency | DLR19_RBS0_STR$ | 19 | |
241 | TTLSLLTD ![]() | Total Sales LTD | Currency | DLR19_RBS0_STR$ | 19 | |
242 | TTLSLLYR ![]() | Total Sales LYR | Currency | DLR19_RBS0_STR$ | 19 | |
243 | TTLSLYTD ![]() | Total Sales YTD | Currency | DLR19_RBS0_STR$ | 19 | |
244 | TCOSTLTD ![]() | Total Costs LTD | Currency | DLR19_RBS0_STR$ | 19 | |
245 | TCOSTLYR ![]() | Total Costs LYR | Currency | DLR19_RBS0_STR$ | 19 | |
246 | TCOSTYTD ![]() | Total Costs YTD | Currency | DLR19_RBS0_STR$ | 19 | |
247 | TCSHRLTD ![]() | Total Cash Received LTD | Currency | DLR19_RBS0_STR$ | 19 | |
248 | TCSHRLYR ![]() | Total Cash Received LYR | Currency | DLR19_RBS0_STR$ | 19 | |
249 | TCSHRYTD ![]() | Total Cash Received YTD | Currency | DLR19_RBS0_STR$ | 19 | |
250 | TFNCHLTD ![]() | Total Finance Charges LTD | Currency | DLR19_RBS0_STR$ | 19 | |
251 | TFNCHLYR ![]() | Total Finance Charges LYR | Currency | DLR19_RBS0_STR$ | 19 | |
252 | TFNCHYTD ![]() | Total Finance Charges YTD | Currency | DLR19_RBS0_STR$ | 19 | |
253 | FNCHCYTD ![]() | Finance Charges CYTD | Currency | DLR19_RBS0_STR$ | 19 | |
254 | FNCHLYRC ![]() | Finance Charges LYR Calendar | Currency | DLR19_RBS0_STR$ | 19 | |
255 | TBDDTLYR ![]() | Total Bad Deb LYR | Currency | DLR19_RBS0_STR$ | 19 | |
256 | TBDDTLTD ![]() | Total Bad Debt LTD | Currency | DLR19_RBS0_STR$ | 19 | |
257 | TBDDTYTD ![]() | Total Bad Debt YTD | Currency | DLR19_RBS0_STR$ | 19 | |
258 | TWVFCLTD ![]() | Total Waived FC LTD | Currency | DLR19_RBS0_STR$ | 19 | |
259 | TWVFCLYR ![]() | Total Waived FC LYR | Currency | DLR19_RBS0_STR$ | 19 | |
260 | TWVFCYTD ![]() | Total Waived FC YTD | Currency | DLR19_RBS0_STR$ | 19 | |
261 | TWROFLTD ![]() | Total Writeoffs LTD | Currency | DLR19_RBS0_STR$ | 19 | |
262 | TWROFLYR ![]() | Total Writeoffs LYR | Currency | DLR19_RBS0_STR$ | 19 | |
263 | TWROFYTD ![]() | Total Writeoffs YTD | Currency | DLR19_RBS0_STR$ | 19 | |
264 | TTLINLTD ![]() | Total # Invoices LTD | Long Integer | LI6_U0 | 6 | |
265 | TTLINLYR ![]() | Total # Invoices LYR | Long Integer | LI6_U0 | 6 | |
266 | TTLINYTD ![]() | Total # Invoices YTD | Long Integer | LI6_U0 | 6 | |
267 | TTLFCLTD ![]() | Total # FC LTD | Long Integer | LI6_U0 | 6 | |
268 | TTLFCLYR ![]() | Total # FC LYR | Long Integer | LI6_U0 | 6 | |
269 | TTLFCYTD ![]() | Total # FC YTD | Long Integer | LI6_U0 | 6 | |
270 | WROFSLIF ![]() | Write Offs LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
271 | WROFSLYR ![]() | Write Offs LYR | Currency | DLR19_RBS0_STR$ | 19 | |
272 | WROFSYTD ![]() | Write Offs YTD | Currency | DLR19_RBS0_STR$ | 19 | |
273 | HIBALLTD ![]() | High Balance LTD | Currency | DLR19_RBSO_STR$ | 19 | |
274 | HIBALLYR ![]() | High Balance LYR | Currency | DLR19_RBSO_STR$ | 19 | |
275 | HIBALYTD ![]() | High Balance YTD | Currency | DLR19_RBSO_STR$ | 19 | |
276 | LASTSTDT ![]() | Last Statement Date | Date | DATE | 6 | |
277 | LSTSTAMT ![]() | Last Statement Amount | Currency | DLR17_RBS0_STR$ | 17 | |
278 | DEPRECV ![]() | Deposits Received | Currency | DLR19_RBS0_STR$ | 19 | |
279 | ONORDAMT ![]() | On Order Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
280 | DISGRPER ![]() | Discount Grace Period | Integer | INT2_U0 | 2 | |
281 | DOCFMTID ![]() | Document Format ID | String | STR15_LBU | 15 | |
282 | DUEGRPER ![]() | Due Date Grace Period | Integer | INT2_U0 | 2 | |
283 | ECTRX ![]() | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
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. | ||||||
284 | Electronic ![]() | Electronic | Boolean | CB_Electronic | 0 | |
285 | CORRNXST ![]() | Correction to Nonexisting Transaction | Boolean | Boolean | 0 | |
286 | DocPrinted ![]() | DocPrinted | Boolean | CB_DocPrinted | 0 | |
Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
287 | DOCNCORR ![]() | Document Number Corrected | String | Document_Number | 20 | |
288 | PSTGSTUS ![]() | Posting Status | Integer | INT | 0 | |
289 | RMTREMSG2 ![]() | RM TRX Posting Error Messages 2 | Long Integer | RM_TRX_Posting_Error_Messages_2 | 0 | |
290 | CUSTNAME1 ![]() | ASI_Customer_Name | String | STR64_Customer_Name | 64 | |
291 | CPRCSTNM1 ![]() | ASI_Corporate_Customer_Number | String | STR15_RM_Customer_Number | 15 | |
292 | ASI_Address_Code ![]() | ASI_Address_Code | String | STR15_Address_Code | 15 | |
293 | SHIPMTHD1 ![]() | ASI_Shipping_Method | String | STR15_Shipping_Method | 15 | |
294 | TAXSCHID1 ![]() | ASI_Tax_Schedule_ID | String | STR15_Tax_Schedule_ID | 15 | |
295 | SLPRSNID1 ![]() | ASI_Salesperson_ID | String | STR15_Salesperson_ID | 15 | |
296 | PYMTRMID1 ![]() | ASI_Payment_Terms_ID | String | STR20_Payment_Terms_ID | 20 | |
297 | CURNCYID1 ![]() | ASI_Currency_ID | String | STR15_Currency_ID | 15 | |
298 | RATETPID1 ![]() | ASI_Rate_Type_ID | String | STR15_Rate_Type_ID | 15 | |
299 | SALSTERR1 ![]() | ASI_Sales_Territory | String | STR15_Sales_Territory | 15 | |
300 | NOTEINDX1 ![]() | ASI_Note_Index | Currency | DLR14 | 14 | |
301 | CREATDDT1 ![]() | ASI_Created_Date | Date | DT | 8 | |
302 | MODIFDT1 ![]() | ASI_Modified_Date | Date | DT | 8 | |
303 | DISGRPER1 ![]() | ASI_Discount_Grace_Period | Integer | INT2_U0 | 2 | |
304 | DUEGRPER1 ![]() | ASI_Due_Date_Grace_Period | Integer | INT2_U0 | 2 | |
305 | Factoring ![]() | Factoring | Boolean | boolean | 0 | |
306 | ORDERFULFILLDEFAULT ![]() | Order Fulfillment Shortage Default | Integer | DDL_OrderFulfillDefault | 0 | |
307 | CUSTPRIORITY ![]() | Customer Priority | Integer | DDL_CustomerPriority | 0 |