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 | |