ASI SOP Line Item SmartList (ASIEXP20)

azurecurveProductsSmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

Display Name: ASI SOP Line Item SmartList
Technical Name: ASI_SOP_LINE_Items_Explorer
Physical Name: ASIEXP20

Sequence Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length
1 ASI_Order_By ASI_Order_By LI_14 Long Integer 4 14
2 ASI_Favorite_Sequence ASI_Favorite_Sequence ASI_LI_10_RU Long Integer 4 10
3 SOPTYPE SOP Type DDL_SOP_Type Integer 2 0
4 SOPNUMBE SOP Number STR20_SOP_Number String 22 17
5 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 4 10
6 CMPNTSEQ Component Sequence LI_Sequence_Number Long Integer 4 10
7 ASI_Document_Status ASI_Document_Status INT Integer 2 0
8 ITEMNMBR Item Number STR30_Item_Number String 32 30
9 ITEMDESC Item Description STR100 String 102 100
10 NONINVEN Non IV INT1 Integer 2 1
11 DROPSHIP Drop Ship INT2 Integer 2 2
12 UOFM U Of M U_Of_M String 10 8
13 LOCNCODE Location Code STR10_Location_Code String 12 10
14 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 10 17
15 ORUNTCST Originating Unit Cost DLR17_RBS0_UTR$ Currency 10 17
16 UNITPRCE Unit Price DLR17_RBS0_STR$ Currency 10 17
17 ORUNTPRC Originating Unit Price DLR17_RBS0_STR$ Currency 10 17
18 XTNDPRCE Extended Price DLR17_RBS0_STR$ Currency 10 17
19 OXTNDPRC Originating Extended Price DLR17_RBS0_STR$ Currency 10 17
20 REMPRICE Remaining Price DLR17_RBS0_UTR$ Currency 10 17
21 OREPRICE Originating Remaining Price DLR17_RBS0_UTR$ Currency 10 17
22 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 10 17
23 OREXTCST Originating Extended Cost DLR17_RBS0_UTR$ Currency 10 17
24 MRKDNAMT Markdown Amount DLR17_RBS0_UTR$ Currency 10 17
25 ORMRKDAM Originating Markdown Amount DLR17_RBS0_UTR$ Currency 10 17
26 MRKDNPCT Markdown Percent INT5_%2 Integer 2 5
27 MRKDNTYP Markdown Type GB Integer 2 0
28 INVINDX Inventory Index LI_14 Long Integer 4 14
29 CSLSINDX Cost Of Sales Index LI_14 Long Integer 4 14
30 SLSINDX Sales Index LI_14 Long Integer 4 14
31 MKDNINDX Markdown Index LI_14 Long Integer 4 14
32 RTNSINDX Returns Index LI_14 Long Integer 4 14
33 INUSINDX In Use Index LI_14 Long Integer 4 14
34 INSRINDX In Service Index LI_14 Long Integer 4 14
35 DMGDINDX Damaged Index LI_14 Long Integer 4 14
36 ITMTSHID Item Tax Schedule ID STR15_LBAU String 16 15
37 IVITMTXB IV Item Taxable DDL_Tax_Options Integer 2 0
38 BKTSLSAM Backout Sales Amount DLR19_RBS0_UTR$ Currency 10 19
39 ORBKTSLS Originating Backout Sales Amount DLR19_RBS0_UTR$ Currency 10 19
40 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 10 17
41 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 10 17
42 TXBTXAMT Taxable Tax Amount DLR19_RBSO_UTR$ Currency 10 19
43 OTAXTAMT Originating Taxable Tax Amount DLR17_RBS0_UTR$ Currency 10 17
44 BSIVCTTL Based On Invoice Total YN Boolean 2 0
45 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 10 17
46 ORTDISAM Originating Trade Discount Amount DLR17_RBS0_UTR$ Currency 10 17
47 DISCSALE Discount Available Sales DLR17_RBS0_UTR$ Currency 10 17
48 ORDAVSLS Originating Discount Available Sales DLR17_RBS0_UTR$ Currency 10 17
49 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 10 17
50 ATYALLOC QTY Allocated DLR17_QTY_RBS0_UTR Currency 10 17
51 QTYINSVC QTY In Service DLR17_QTY_RBS0_UTR Currency 10 17
52 QTYINUSE QTY In Use DLR17_QTY_RBS0_UTR Currency 10 17
53 QTYDMGED QTY Damaged DLR17_QTY_RBS0_UTR Currency 10 17
54 QTYRTRND QTY Returned DLR17_QTY_RBS0_UTR Currency 10 17
55 QTYONHND QTY On Hand DLR17_QTY_RBS0_STR Currency 10 17
56 QTYCANCE QTY Canceled DLR17_QTY_RBS0_UTR Currency 10 17
57 QTYCANOT QTY Canceled Other DLR17_QTY_RBS0_UTR Currency 10 17
58 QTYORDER QTY Ordered DLR17_QTY_RBS0_UTR Currency 10 17
59 QTYPRBAC QTY Prev Back Ordered DLR17_QTY_RBS0_UTR Currency 10 17
60 QTYPRBOO QTY Prev BO On Order DLR17_QTY_RBS0_UTR Currency 10 17
61 QTYPRINV QTY Prev Invoiced DLR17_QTY_RBS0_UTR Currency 10 17
62 QTYPRORD QTY Prev Ordered DLR17_QTY_RBS0_UTR Currency 10 17
63 QTYREMAI QTY Remaining DLR17_QTY_RBS0_UTR Currency 10 17
64 QTYREMBO QTY Remaining On BO DLR17_QTY_RBS0_UTR Currency 10 17
65 QTYTBAOR QTY To Back Order DLR17_QTY_RBS0_UTR Currency 10 17
66 QTYTOINV QTY To Invoice DLR17_QTY_RBS0_UTR Currency 10 17
67 QTYTORDR QTY To Order DLR17_QTY_RBS0_UTR Currency 10 17
68 QTYFULFI QTY Fulfilled DLR17_QTY_RBS0_UTR Currency 10 17
69 QTYSLCTD QTY Selected DLR17_QTY_RBS0_UTR Currency 10 17
70 QTYBSUOM QTY In Base U Of M DLR17_QTY_RBS0_STR Currency 10 17
71 EXTQTYAL Existing Qty Available DLR17_RBS0_UTR$ Currency 10 17
72 EXTQTYSEL Existing Qty Selected DLR17_QTY_RBS0_STR Currency 10 17
73 ReqShipDate Requested Ship Date DT Date 4 8
74 FUFILDAT Fulfillment Date DT Date 4 8
75 ACTLSHIP Actual Ship Date DT Date 4 8
76 SHIPMTHD Shipping Method STR15_Shipping_Method String 16 15
77 SALSTERR Sales Territory STR15_Sales_Territory String 16 15
78 SLPRSNID Salesperson ID STR15_Salesperson_ID String 16 15
79 PRCLEVEL PriceLevel STR10_LBAU String 12 10
80 COMMNTID Comment ID STR15_Comment_ID String 16 15
81 BRKFLD1 Break Field 1 INT1 Integer 2 1
82 BRKFLD2 Break Field 2 INT1 Integer 2 1
83 BRKFLD3 Break Field 3 INT1 Integer 2 1
84 CURRNIDX Currency Index INT3 Integer 2 3
85 TRXSORCE TRX Source STR13 String 14 13
86 SOPLNERR SOP LINE Errors ML_SOP_LINE_Errors Long Integer 4 0
87 PURCHSTAT Purchasing Status DDL_PurchasingStatus Integer 2 0
88 QTYONPO QTY On PO DLR17_QTY_RBS0_UTR Currency 10 17
89 QTYRECVD QTY Received DLR17_QTY_RBS0_UTR Currency 10 17
90 QTYPRVRECVD QTY Prev Received DLR17_QTY_RBS0_UTR Currency 10 17
91 ORIGTYPE Original Type DDL_SOP_Type Integer 2 0
92 DOCID Document ID STR15_LBAU String 16 15
93 DOCDATE Document Date DT Date 4 8
94 GLPOSTDT GL Posting Date DT Date 4 8
95 QUOTEDAT Quote Date DT Date 4 8
96 QUOEXPDA Quote Expiration Date DT Date 4 8
97 ORDRDATE Order Date DT Date 4 8
98 INVODATE Invoice Date DT Date 4 8
99 BACKDATE Back Order Date DT Date 4 8
100 RETUDATE Return Date DT Date 4 8
101 DISCDATE Discount Date DT Date 4 8
102 DUEDATE Due Date DT Date 4 8
103 REPTING Repeating CB_Repeating Boolean 2 0
104 TRXFREQU TRX Frequency DDL_TRX_Frequency Integer 2 0
105 TIMEREPD Times Repeated INT4_U0 Integer 2 4
106 DYSTINCR Days to Increment INT3_RB0_U Integer 2 3
107 DTLSTREP Date Last Repeated DT Date 4 8
108 DSTBTCH1 Dest Batch 1 STR15_LBAU String 16 15
109 DSTBTCH2 Dest Batch 2 STR15_LBAU String 16 15
110 USDOCID1 Use Document ID 1 STR15_LBAU String 16 15
111 USDOCID2 Use Document ID 2 STR15_LBAU String 16 15
112 DISCFRGT Discount Available Freight DLR17_RBS0_UTR$ Currency 10 17
113 ORDAVFRT Originating Discount Available Freight DLR17_RBS0_UTR$ Currency 10 17
114 DISCMISC Discount Available Misc DLR17_RBS0_UTR$ Currency 10 17
115 ORDAVMSC Originating Discount Available Misc DLR17_RBS0_UTR$ Currency 10 17
116 DISAVAMT Discount Available Amount DLR17_RBS0_UTR$ Currency 10 17
117 ORDAVAMT Originating Discount Available Amount DLR17_RBS0_UTR$ Currency 10 17
118 DISCRTND Discount Returned DLR17_RBS0_STR$ Currency 10 17
119 ORDISRTD Originating Discount Returned DLR17_RBS0_STR$ Currency 10 17
120 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 10 17
121 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 10 17
122 DSCPCTAM Discount Percent Amount INT5_%2 Integer 2 5
123 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 10 11
124 ORDATKN Originating Discount Available Taken DLR17_RBS0_UTR$ Currency 10 17
125 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 22 20
126 BCHSOURC Batch Source STR15 String 16 15
127 BACHNUMB Batch Number STR15_LBAU String 16 15
128 CUSTNMBR Customer Number STR15_RM_Customer_Number String 16 15
129 CUSTNAME Customer Name STR64_Customer_Name String 66 64
130 CSTPONBR Customer PO Number STR20_Document_Number String 22 20
131 PROSPECT Prospect INT1 Integer 2 1
132 MSTRNUMB Master Number LI_MasterNumber Long Integer 4 9
133 PCKSLPNO Packing Slip Number STR20_IVC_Document_Number String 22 17
134 PICTICNU Picking Ticket Number STR20_SOP_Number String 22 17
135 PRBTADCD Primary Billto Address Code STR15_LBAU String 16 15
136 PRSTADCD Primary Shipto Address Code STR15_LBAU String 16 15
137 CNTCPRSN Contact Person STR60 String 62 60
138 ShipToName ShipToName STR64_Customer_Name String 66 64
139 ADDRESS1 Address 1 STR60 String 62 60
140 ADDRESS2 Address 2 STR60 String 62 60
141 ADDRESS3 Address 3 STR60 String 62 60
142 CITY City STR35 String 36 35
143 STATE State STR30_State String 30 29
144 ZIPCODE Zip Code STR10 String 12 10
145 COUNTRY Country STR60 String 62 60
146 PHNUMBR1 Phone Number 1 Phone_Number String 22 14
147 PHNUMBR2 Phone Number 2 Phone_Number String 22 14
148 FAXNUMBR Fax Number STR14_FAX String 22 14
149 COMAPPTO Commission Applied To GB Integer 2 0
150 COMMAMNT Commission Amount DLR17_RBS0_STR$ Currency 10 17
151 OCOMMAMT Originating Commission Amount DLR17_RBSO_STR$ Currency 10 17
152 CMMSLAMT Commission Sale Amount DLR17_RBS0_STR$ Currency 10 17
153 ORCOSAMT Originating Commission Sales Amount DLR17_RBS0_STR$ Currency 10 17
154 NCOMAMNT Non-Commissioned Amount DLR19_RBS0_STR$ Currency 10 19
155 ORNCMAMT Originating Non-Commissioned Amount DLR19_RBS0_STR$ Currency 10 19
156 TRDISPCT Trade Discount Percent INT4_%2 Integer 2 4
157 SUBTOTAL Subtotal DLR17_RBS0_STR$ Currency 10 17
158 ORSUBTOT Originating Subtotal DLR17_RBS0_STR$ Currency 10 17
159 REMSUBTO Remaining Subtotal DLR17_RBS0_UTR$ Currency 10 17
160 OREMSUBT Originating Remaining Subtotal DLR17_RBS0_UTR$ Currency 10 17
161 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 10 17
162 ORFRTAMT Originating Freight Amount DLR17_RBS0_UTR$ Currency 10 17
163 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 10 17
164 ORMISCAMT Originating Misc Amount DLR19_RBSO_UTR$ Currency 10 19
165 TXENGCLD Tax Engine Called YN Boolean 2 0
166 TAXEXMT1 Tax Exempt 1 STR25 String 26 25
167 TAXEXMT2 Tax Exempt 2 STR25 String 26 25
168 TXRGNNUM Tax Registration Number STR25 String 26 25
169 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 16 15
170 TXSCHSRC Tax Schedule Source INT1 Integer 2 1
171 FRTSCHID Freight Schedule ID STR15_LBAU String 16 15
172 FRTTXAMT Freight Tax Amount DLR19_RBSO_UTR$ Currency 10 19
173 ORFRTTAX Originating Freight Tax Amount DLR19_RBSO_UTR$ Currency 10 19
174 FRGTTXBL Freight Taxable DDL_Tax_Options Integer 2 0
175 MSCSCHID Misc Schedule ID STR15_LBAU String 16 15
176 MSCTXAMT Misc Tax Amount DLR19_RBSO_UTR$ Currency 10 19
177 ORMSCTAX Originating Misc Tax Amount DLR19_RBSO_UTR$ Currency 10 19
178 MISCTXBL Misc Taxable DDL_Tax_Options Integer 2 0
179 BKTFRTAM Backout Freight Amount DLR19_RBS0_UTR$ Currency 10 19
180 ORBKTFRT Originating Backout Freight Amount DLR19_RBS0_UTR$ Currency 10 19
181 BKTMSCAM Backout Misc Amount DLR19_RBS0_UTR$ Currency 10 19
182 ORBKTMSC Originating Backout Misc Amount DLR19_RBS0_UTR$ Currency 10 19
183 BCKTXAMT Backout Tax Amount DLR17_RBS0_UTR$ Currency 10 17
184 OBTAXAMT Originating Backout Tax Amount DLR17_RBS0_UTR$ Currency 10 17
185 ECTRX EC Transaction CB_EC_Transaction Boolean 2 0
186 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 10 19
187 ORDOCAMT Originating Document Amount DLR17_RBS0_STR$ Currency 10 17
188 PYMTRCVD Payment Received DLR19_RBS0_UTR$ Currency 10 19
189 ORPMTRVD Originating Payment Received DLR19_RBS0_UTR$ Currency 10 19
190 DEPRECVD Deposit Received DLR19_RBS0_UTR$ Currency 10 19
191 ORDEPRVD Originating Deposit Received DLR19_RBS0_UTR$ Currency 10 19
192 CODAMNT COD Amount DLR17_RBS0_UTR$ Currency 10 17
193 ORCODAMT Originating COD Amount DLR17_RBS0_UTR$ Currency 10 17
194 ACCTAMNT Account Amount DLR19_RBS0_UTR$ Currency 10 19
195 ORACTAMT Originating Account Amount DLR19_RBS0_UTR$ Currency 10 19
196 UPSZONE UPS Zone STR3 String 4 3
197 TIMESPRT Times Printed INT4_U0 Integer 2 4
198 PSTGSTUS Posting Status INT Integer 2 0
199 VOIDSTTS Void Status INT Integer 2 0
200 ALLOCABY Allocate By DDL_Allocate_By Integer 2 0
201 CURNCYID Currency ID STR15_Currency_ID String 16 15
202 RATETPID Rate Type ID STR15_Rate_Type_ID String 16 15
203 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 16 15
204 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 10 14
205 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 10 14
206 EXCHDATE Exchange Date DT_Date Date 4 6
207 TIME1 Time TM6 Time 4 6
208 RTCLCMTD Rate Calculation Method GB Integer 2 0
209 MCTRXSTT MC Transaction State INT1 Integer 2 1
210 SOPHDRE1 SOP HDR Errors 1 ML_SOP_HDR_Errors_1 Long Integer 4 0
211 SOPHDRE2 SOP HDR Errors 2 ML_SOP_HDR_Errors_2 Long Integer 4 0
212 SOPHDRFL SOP HDR Flags ML_SOP_HDR_Flags Long Integer 4 0
213 REFRENCE Reference STR30 String 32 30
214 POSTEDDT Posted Date DATE Date 4 6
215 PTDUSRID Posted User ID STR15 String 16 15
216 USER2ENT User To Enter STR15_User_ID String 16 15
217 CREATDDT Created Date DT Date 4 8
218 MODIFDT Modified Date DT Date 4 8
219 Tax_Date Tax Date DT Date 4 8
220 ITMSHNAM Item Short Name STR15 String 16 15
221 ITEMTYPE Item Type DDL_Item_Type Integer 2 0
222 ITMGEDSC Item Generic Description STR10 String 12 10
223 STNDCOST Standard Cost DLR17_RBS0_UTR$ Currency 10 17
224 CURRCOST Current Cost DLR17_RBS0_UTR$ Currency 10 17
225 LISTPRCE List Price DLR17_RBS0_STR$ Currency 10 17
226 ITEMSHWT Item Shipping Weight LI6_RBS2_UT Long Integer 4 6
227 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 2 0
228 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 2 0
229 TAXOPTNS Tax Options DDL_Tax_Options Integer 2 0
230 COMMCODE Commission Code STR15_LBAU String 16 15
231 IVIVINDX IV IV Index LI_14 Long Integer 4 14
232 IVIVOFIX IV IV Offset Index LI_14 Long Integer 4 14
233 IVCOGSIX IV COGS Index LI_14 Long Integer 4 14
234 IVSLSIDX IV Sales Index LI_14 Long Integer 4 14
235 IVSLDSIX IV Sales Discounts Index LI_14 Long Integer 4 14
236 IVSLRNIX IV Sales Returns Index LI_14 Long Integer 4 14
237 IVINUSIX IV In Use Index LI_14 Long Integer 4 14
238 IVINSVIX IV In Service Index LI_14 Long Integer 4 14
239 IVDMGIDX IV Damaged Index LI_14 Long Integer 4 14
240 IVVARIDX IV Variances Index LI_14 Long Integer 4 14
241 DPSHPIDX Drop Ship Index LI_14 Long Integer 4 14
242 PURPVIDX Purchase Price Variance Index LI_14 Long Integer 4 14
243 IVRETIDX Inventory Returns Index LI_14 Long Integer 4 14
244 ASMVRIDX Assembly Variance Index LI_14 Long Integer 4 14
245 ITMCLSCD Item Class Code STR10_Class_ID String 12 10
246 ITMTRKOP Item Tracking Option DDL_Track Integer 2 0
247 LOTTYPE Lot Type STR10_Lot_Type String 12 10
248 KPERHIST Keep Period History CB_Keep_Period_History Boolean 2 0
249 KPTRXHST Keep Trx History CB_Keep_Trx_History Boolean 2 0
250 KPCALHST Keep Calendar History CB_Keep_Calendar_History Boolean 2 0
251 KPDSTHST Keep Distribution History CB_Keep_Dist_History Boolean 2 0
252 ALWBKORD Allow Back Orders CB_Allow_Back_Orders Boolean 2 0
253 VCTNMTHD Valuation Method DDL_Valuation_Method Integer 2 0
254 UOMSCHDL U Of M Schedule STR10_Schedule String 12 10
255 ObjRef1 ObjRef1 Reference Reference 0 0
256 ALTITEM1 Alternate Item 1 STR30_Item_Number String 32 30
257 ALTITEM2 Alternate Item 2 STR30_Item_Number String 32 30
258 USCATVLS User Category Values User_Category_Value String 12 10
259 MSTRCDTY Master Record Type INT1 Integer 2 1
260 WRNTYDYS Warranty Days INT4 Integer 2 4
261 ORIGNUMB Original Number STR20_SOP_Number String 22 17
262 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 10 17
263 TIMETREP Times To Repeat INT4_U0 Integer 2 4
264 ORDDLRAT Originating Discount Dollar Amount DLR11_RBS0_UTR$ Currency 10 11
265 SOPMCERR SOP MC Posting Error Messages SOP MC Posting Error Messages Long Integer 4 0
266 NOTEINDX Note Index DLR14 Currency 10 14
267 CUSTCLAS Customer Class STR15_Customer_Class String 16 15
268 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 16 15
269 STMTNAME Statement Name STR64 String 66 64
270 ADRSCODE Address Code STR15_Address_Code String 16 15
271 STADDRCD Statement Address Code STR15_LBAU String 16 15
272 CHEKBKID Checkbook ID STR15_Checkbook_ID String 16 15
273 CRLMTTYP Credit Limit Type GB_Amt_Type Integer 2 0
274 CRLMTAMT Credit Limit Amount DLR17_RBS0_UTR$ Currency 10 17
275 CRLMTPER Credit Limit Period DDL Integer 2 0
276 CRLMTPAM Credit Limit Period Amount DLR17_RBS0_UTR$ Currency 10 17
277 CUSTDISC Customer Discount INT5_%2 Integer 2 5
278 SHRTNAME Short Name STR15 String 16 15
279 MINPYTYP Minimum Payment Type GB_Amt_Type Integer 2 0
280 MINPYDLR Minimum Payment Dollar DLR17_RBS0_UTR$ Currency 10 17
281 MINPYPCT Minimum Payment Percent INT5_%2 Integer 2 5
282 FNCHATYP Finance Charge Amt Type GB_Amt_Type Integer 2 0
283 FNCHPCNT Finance Charge Percent INT5_%2 Integer 2 5
284 FINCHDLR Finance Charge Dollar DLR17_RBS0_UTR$ Currency 10 17
285 MXWOFTYP Maximum Writeoff Type GP_Max_Writeoff Integer 2 0
286 MXWROFAM Max Writeoff Amount DLR17_RBS0_UTR$ Currency 10 17
287 USERDEF1 User Defined 1 STR20 String 22 20
288 USERDEF2 User Defined 2 STR20 String 22 20
289 BALNCTYP Balance Type GB_Bal_Type Integer 2 0
290 STMTCYCL Statement Cycle DDL_Stmt_Cycle Integer 2 0
291 BANKNAME Bank Name STR30 String 32 30
292 BNKBRNCH Bank Branch STR20 String 22 20
293 DEFCACTY Default Cash Account Type GB Integer 2 0
294 RMCSHACC RM Cash Account Index LI_14 Long Integer 4 14
295 RMARACC RM AR Account Index LI_14 Long Integer 4 14
296 RMSLSACC RM Sales Account Index LI_14 Long Integer 4 14
297 RMIVACC RM IV Account Index LI_14 Long Integer 4 14
298 RMCOSACC RM Cost Of Sales Account Index LI_14 Long Integer 4 14
299 RMTAKACC RM Discounts Taken Account Index LI_14 Long Integer 4 14
300 RMAVACC RM Discounts Avail Account Index LI_14 Long Integer 4 14
301 RMFCGACC RM Finance Charge Account Index LI_14 Long Integer 4 14
302 RMWRACC RM Writeoff Account Index LI_14 Long Integer 4 14
303 FRSTINDT First Invoice Date DT_Date Date 4 6
304 INACTIVE Inactive CB_Inactive Boolean 2 0
305 HOLD Hold CB_Hold Boolean 2 0
306 CRCARDID Credit Card ID STR15 String 16 15
307 CRCRDNUM Credit Card Number STR20 String 22 20
308 CCRDXPDT Credit Card Exp Date DT_Date Date 4 6
309 Revalue_Customer Revalue Customer CB Revalue Customer Boolean 2 0
310 Post_Results_To Post Results To GB Integer 2 0
311 FINCHID Finance Charge ID STR15_Charge_ID String 16 15
312 GOVCRPID Governmental Corporate ID STR30_Gov_Corp_ID String 32 30
313 GOVINDID Governmental Individual ID STR30_Gov_Indiv_ID String 32 30
314 TNSFCLIF Total Amount Of NSF Checks Life DLR19_RBS0_STR$ Currency 10 19
315 NONSFLIF Number Of NSF Checks Life LI6_U0 Long Integer 4 6
316 CUSTBLNC Customer Balance DLR19_RBS0_STR$ Currency 10 19
317 AGPERAMT Aging Period Amounts DLR17_RBSO_STR$ Currency 10 17
318 LASTAGED Last Aged DATE Date 4 6
319 LSTNSFCD Last NSF Check Date DT_Date Date 4 6
320 LPYMTAMT Last Payment Amount DLR17_RBS0_STR$ Currency 10 17
321 LASTPYDT Last Payment Date DT_Date Date 4 6
322 LSTTRXDT Last Transaction Date DT_Date Date 4 6
323 LSTTRXAM Last Transaction Amount DLR17_RBS0_STR$ Currency 10 17
324 LSTFCHAM Last Finance Charge Amount DLR19_RBS0_STR$ Currency 10 19
325 UPFCHYTD Unpaid Finance Charges YTD DLR17_RBS0_UTR$ Currency 10 17
326 AVDTPLYR Average Days to Pay – LYR INT3_U0 Integer 2 3
327 AVDTPLIF Average Days To Pay – Life INT3_U0 Integer 2 3
328 AVGDTPYR Average Days To Pay – Year INT3_U0 Integer 2 3
329 NUMADTPL Number ADTP Documents – Life Long_10U Long Integer 4 10
330 NUMADTPR Number ADTP Documents – LYR Long_10U Long Integer 4 10
331 NUMADTPY Number ADTP Documents – Year Long_10U Long Integer 4 10
332 TDTKNLTD Total Discounts Taken LTD DLR19_RBS0_STR$ Currency 10 19
333 TDTKNLYR Total Discounts Taken LYR DLR19_RBS0_STR$ Currency 10 19
334 TDTKNYTD Total Discounts Taken YTD DLR19_RBS0_STR$ Currency 10 19
335 TDISAYTD Total Discounts Available YTD DLR19_RBS0_STR$ Currency 10 19
336 RETAINAG Retainage DLR19_RBS0_STR$ Currency 10 19
337 TNSFCYTD Total Amount Of NSF Checks YTD DLR19_RBS0_STR$ Currency 10 19
338 NONSFYTD Number Of NSF Checks YTD LI6_U0 Long Integer 4 6
339 UNPSTDSA Unposted Sales Amount DLR19_RBS0_UTR$ Currency 10 19
340 UNPSTDCA Unposted Cash Amount DLR19_RBS0_UTR$ Currency 10 19
341 UNPSTOSA Unposted Other Sales Amount DLR19_RBS0_UTR$ Currency 10 19
342 UNPSTOCA Unposted Other Cash Amount DLR19_RBS0_UTR$ Currency 10 19
343 NCSCHPMT Non Current Scheduled Payments DLR19_RBS0_STR$ Currency 10 19
344 TTLSLLTD Total Sales LTD DLR19_RBS0_STR$ Currency 10 19
345 TTLSLLYR Total Sales LYR DLR19_RBS0_STR$ Currency 10 19
346 TTLSLYTD Total Sales YTD DLR19_RBS0_STR$ Currency 10 19
347 TCOSTLTD Total Costs LTD DLR19_RBS0_STR$ Currency 10 19
348 TCOSTLYR Total Costs LYR DLR19_RBS0_STR$ Currency 10 19
349 TCOSTYTD Total Costs YTD DLR19_RBS0_STR$ Currency 10 19
350 TCSHRLTD Total Cash Received LTD DLR19_RBS0_STR$ Currency 10 19
351 TCSHRLYR Total Cash Received LYR DLR19_RBS0_STR$ Currency 10 19
352 TCSHRYTD Total Cash Received YTD DLR19_RBS0_STR$ Currency 10 19
353 TFNCHLTD Total Finance Charges LTD DLR19_RBS0_STR$ Currency 10 19
354 TFNCHLYR Total Finance Charges LYR DLR19_RBS0_STR$ Currency 10 19
355 TFNCHYTD Total Finance Charges YTD DLR19_RBS0_STR$ Currency 10 19
356 FNCHCYTD Finance Charges CYTD DLR19_RBS0_STR$ Currency 10 19
357 FNCHLYRC Finance Charges LYR Calendar DLR19_RBS0_STR$ Currency 10 19
358 TBDDTLYR Total Bad Deb LYR DLR19_RBS0_STR$ Currency 10 19
359 TBDDTLTD Total Bad Debt LTD DLR19_RBS0_STR$ Currency 10 19
360 TBDDTYTD Total Bad Debt YTD DLR19_RBS0_STR$ Currency 10 19
361 TWVFCLTD Total Waived FC LTD DLR19_RBS0_STR$ Currency 10 19
362 TWVFCLYR Total Waived FC LYR DLR19_RBS0_STR$ Currency 10 19
363 TWVFCYTD Total Waived FC YTD DLR19_RBS0_STR$ Currency 10 19
364 TWROFLTD Total Writeoffs LTD DLR19_RBS0_STR$ Currency 10 19
365 TWROFLYR Total Writeoffs LYR DLR19_RBS0_STR$ Currency 10 19
366 TWROFYTD Total Writeoffs YTD DLR19_RBS0_STR$ Currency 10 19
367 TTLINLTD Total # Invoices LTD LI6_U0 Long Integer 4 6
368 TTLINLYR Total # Invoices LYR LI6_U0 Long Integer 4 6
369 TTLINYTD Total # Invoices YTD LI6_U0 Long Integer 4 6
370 TTLFCLTD Total # FC LTD LI6_U0 Long Integer 4 6
371 TTLFCLYR Total # FC LYR LI6_U0 Long Integer 4 6
372 TTLFCYTD Total # FC YTD LI6_U0 Long Integer 4 6
373 WROFSLIF Write Offs LIFE DLR19_RBS0_STR$ Currency 10 19
374 WROFSLYR Write Offs LYR DLR19_RBS0_STR$ Currency 10 19
375 WROFSYTD Write Offs YTD DLR19_RBS0_STR$ Currency 10 19
376 HIBALLTD High Balance LTD DLR19_RBSO_STR$ Currency 10 19
377 HIBALLYR High Balance LYR DLR19_RBSO_STR$ Currency 10 19
378 HIBALYTD High Balance YTD DLR19_RBSO_STR$ Currency 10 19
379 LASTSTDT Last Statement Date DATE Date 4 6
380 LSTSTAMT Last Statement Amount DLR17_RBS0_STR$ Currency 10 17
381 DEPRECV Deposits Received DLR19_RBS0_STR$ Currency 10 19
382 ONORDAMT On Order Amount DLR19_RBS0_UTR$ Currency 10 19
383 DISGRPER Discount Grace Period INT2_U0 Integer 2 2
384 DOCFMTID Document Format ID STR15_LBU String 16 15
385 DUEGRPER Due Date Grace Period INT2_U0 Integer 2 2
386 APLYWITH Apply Withholding Boolean Boolean 2 0
387 CORRCTN Correction CB_Correction Boolean 2 0
388 DOCNCORR Document Number Corrected Document_Number String 22 20
389 PHONE3 Phone 3 Phone_Number3 String 22 14
390 SALEDATE Sale Date DT Date 4 8
391 SEQNCORR Sequence Number Corrected INT Integer 2 0
392 SHPPGDOC Shipping Document CB_Shipping_Document Boolean 2 0
393 SIMPLIFD Simplified CB_Simplified Boolean 2 0
394 WITHHAMT Withholding Amount DLR19_RBSO_UTR$ Currency 10 19
395 CORRNXST Correction to Nonexisting Transaction Boolean Boolean 2 0
396 SOPHDRE3 SOP HDR Errors 3 ML_SOP_HDR_Errors_3 Long Integer 4 0
397 ABCCODE ABC Code DDL_ABC_Code Integer 2 0
398 CGSINFLX COGS Inflation Index LI_14 Long Integer 4 14
399 CGSMCIDX COGS Monetary Correction Index LI_14 Long Integer 4 14
400 IVINFIDX Inventory Inflation Index LI_14 Long Integer 4 14
401 INVMCIDX Inventory Monetary Correction Index LI_14 Long Integer 4 14
402 ITEMCODE Item Code STR15 String 16 15
403 KTACCTSR Kit COGS Account Source GB Integer 2 0
404 LASTGENSN Last Generated Serial Number STR20_LBAU String 22 20
405 PriceGroup Price Group STR10_LBAU String 12 10
406 PRICMTHD Price Method DDL_Price_Method Integer 2 0
407 PINFLIDX Purch Inflation Index LI_14 Long Integer 4 14
408 PURMCIDX Purch Monetary Correction Index LI_14 Long Integer 4 14
409 PRCHSUOM Purchasing U Of M U_Of_M String 10 8
410 SELNGUOM Selling U Of M U_Of_M String 10 8
411 TCC Tax Commodity Code STR30_VAT String 32 30
412 UPPVIDX Unrealized Purchase Price Variance Index LI_14 Long Integer 4 14
413 ORGSEQNM Original Sequence Number Corrected LI_Sequence_Number Long Integer 4 10
414 ODECPLCU Originating Decimal Places Currency DDL_Decimal_Places_Dollars Integer 2 0
415 TTLRTLTD Total Returns LTD DLR19_RBS0_STR$ Currency 10 19
416 TTLRTLYR Total Returns LYR DLR19_RBS0_STR$ Currency 10 19
417 TTLRTYTD Total Returns YTD DLR19_RBS0_STR$ Currency 10 19
418 CUSTNAME1 ASI_Customer_Name STR64_Customer_Name String 66 64
419 CNTCPRSN1 ASI_Contact_Person STR60 String 62 60
420 ASI_Address_Code ASI_Address_Code STR15_Address_Code String 16 15
421 UPSZONE1 ASI_UPS_Zone STR3 String 4 3
422 SHIPMTHD1 ASI_Shipping_Method STR15_Shipping_Method String 16 15
423 TAXSCHID1 ASI_Tax_Schedule_ID STR15_Tax_Schedule_ID String 16 15
424 ADDRESS11 ASI_Address_1 STR60 String 62 60
425 ADDRESS21 ASI_Address_2 STR60 String 62 60
426 ADDRESS31 ASI_Address_3 STR60 String 62 60
427 COUNTRY1 ASI_Country STR60 String 62 60
428 CITY1 ASI_City STR35 String 36 35
429 STATE1 ASI_State STR30_State String 30 29
430 ZIP1 ASI_Zip STR10 String 12 10
431 PHONE11 ASI_Phone_1 Phone_Number String 22 14
432 PHONE21 ASI_Phone_2 Phone_Number String 22 14
433 FAX1 ASI_Fax STR14_FAX String 22 14
434 PRBTADCD1 ASI_Primary_Billto_Address_Code STR15_LBAU String 16 15
435 PRSTADCD1 ASI_Primary_Shipto_Address_Code STR15_LBAU String 16 15
436 SLPRSNID1 ASI_Salesperson_ID STR15_Salesperson_ID String 16 15
437 PYMTRMID1 ASI_Payment_Terms_ID STR20_Payment_Terms_ID String 22 20
438 CURNCYID1 ASI_Currency_ID STR15_Currency_ID String 16 15
439 RATETPID1 ASI_Rate_Type_ID STR15_Rate_Type_ID String 16 15
440 PRCLEVEL1 ASI_PriceLevel STR10_LBAU String 12 10
441 COMMENT11 ASI_Comment1 STR30 String 32 30
442 COMMENT21 ASI_Comment2 STR30 String 32 30
443 TXRGNNUM1 ASI_Tax_Registration_Number STR25 String 26 25
444 TAXEXMT11 ASI_Tax_Exempt_1 STR25 String 26 25
445 TAXEXMT21 ASI_Tax_Exempt_2 STR25 String 26 25
446 SALSTERR1 ASI_Sales_Territory STR15_Sales_Territory String 16 15
447 KPCALHST1 ASI_Keep_Calendar_History CB_Keep_Calendar_History Boolean 2 0
448 KPDSTHST1 ASI_Keep_Distribution_History CB_Keep_Dist_History Boolean 2 0
449 KPERHIST1 ASI_Keep_Period_History CB_Keep_Period_History Boolean 2 0
450 KPTRXHST1 ASI_Keep_Trx_History CB_Keep_Trx_History Boolean 2 0
451 NOTEINDX1 ASI_Note_Index DLR14 Currency 10 14
452 CREATDDT1 ASI_Created_Date DT Date 4 8
453 MODIFDT1 ASI_Modified_Date DT Date 4 8
454 PHONE31 ASI_Phone_3 Phone_Number String 22 14
455 ITEMDESC1 ASI_Item_Description STR50 String 52 50
456 ITMTSHID1 ASI_Item_Tax_Schedule_ID STR15_LBAU String 16 15
457 PRCLEVEL11 ASI_PriceLevel2 STR10_LBAU String 12 10
458 DECPLQTY1 ASI_Decimal_Places_QTYS DDL_Decimal_Places_QTYS Integer 2 0
459 DECPLCUR1 ASI_Decimal_Places_Currency DDL_Decimal_Places_Dollars Integer 2 0
460 ITEMCODE1 ASI_Item_Code STR15 String 16 15
461 ReqShipDate1 ASI_Requested_Ship_Date DT Date 4 8
462 FUFILDAT1 ASI_Fulfillment_Date DT Date 4 8
463 ACTLSHIP1 ASI_Actual_Ship_Date DT Date 4 8
464 PRCLEVEL111 ASI_PriceLevel3 STR10_LBAU String 12 10
465 LOCNCODE1 ASI_Location_Code STR10_Location_Code String 12 10
466 MRKDNAMT1 ASI_Markdown_Amount DLR17_RBS0_UTR$ Currency 10 17
467 SHIPMTHD11 ASI_Shipping_Method2 STR15_Shipping_Method String 16 15
468 TRDISAMT1 ASI_Trade_Discount_Amount DLR17_RBS0_UTR$ Currency 10 17
469 EXTDCOST1 ASI_Extended_Cost DLR17_RBS0_UTR$ Currency 10 17
470 TXBTXAMT1 ASI_Taxable_Tax_Amount DLR19_RBSO_UTR$ Currency 10 19
471 TAXAMNT1 ASI_Tax_Amount DLR17_RBS0_UTR$ Currency 10 17
472 SALSTERR11 ASI_Sales_Territory2 STR15_Sales_Territory String 16 15
473 SLPRSNID11 ASI_Salesperson_ID2 STR15_Salesperson_ID String 16 15
474 TRXSORCE1 ASI_TRX_Source STR13 String 14 13
475 COMMNTID1 ASI_Comment_ID STR15_Comment_ID String 16 15
476 CREATDDT11 ASI_Created_Date2 DT Date 4 8
477 MODIFDT11 ASI_Modified_Date2 DT Date 4 8
478 ORMRKDAM1 ASI_Originating_Markdown_Amount DLR17_RBS0_UTR$ Currency 10 17
479 ORTDISAM1 ASI_Originating_Trade_Discount_Amount DLR17_RBS0_UTR$ Currency 10 17
480 BSIVCTTL1 ASI_Based_On_Invoice_Total YN Boolean 2 0
481 OREXTCST1 ASI_Originating_Extended_Cost DLR17_RBS0_UTR$ Currency 10 17
482 OTAXTAMT1 ASI_Originating_Taxable_Tax_Amount DLR17_RBS0_UTR$ Currency 10 17
483 ORTAXAMT1 ASI_Originating_Tax_Amount DLR17_RBS0_UTR$ Currency 10 17
484 NOTEINDX11 ASI_Note_Index2 DLR14 Currency 10 14
485 ASI_Currency_Index ASI_Currency_Index INT3 Integer 2 3
486 SOPLNERR1 ASI_SOP_LINE_Errors_MSLB ML_SOP_LINE_Errors Long Integer 4 0
487 LOCNCODE11 ASI_Location_Code2 STR10_Location_Code String 12 10
488 DOCNCORR1 ASI_Document_Number_Corrected Document_Number String 22 20
489 TAXSCHID2 ASI_Tax_Schedule_ID_2 STR15_Tax_Schedule_ID String 16 15
490 PRSTADCD2 ASI_Primary_Shipto_Address_Code_2 STR15_LBAU String 16 15
491 ShipToName1 ASI_ShipToName STR64_Customer_Name String 66 64
492 CNTCPRSN2 ASI_Contact_Person_2 STR60 String 62 60
493 ADDRESS111 ASI_Address_12 STR60 String 62 60
494 ADDRESS211 ASI_Address_22 STR60 String 62 60
495 ADDRESS311 ASI_Address_32 STR60 String 62 60
496 CITY11 ASI_City2 STR35 String 36 35
497 STATE11 ASI_State2 STR30_State String 30 29
498 ZIPCODE1 ASI_Zip_Code STR10 String 12 10
499 COUNTRY11 ASI_Country2 STR60 String 62 60
500 PHONE1 Phone 1 Phone_Number String 22 14
501 PHONE2 Phone 2 Phone_Number String 22 14
502 PHONE311 ASI_Phone_32 Phone_Number String 22 14
503 FAXNUMBR1 ASI_Fax_Number STR14_FAX String 22 14
504 EXCEPTIONALDEMAND Exceptional Demand CB_Exceptional_Demand Boolean 2 0
505 ASI_Tax_Schedule_Source ASI_Tax_Schedule_Source ASI_Tax_Schedule_Source Integer 2 0
506 CONTNBR Contract Number STR11 String 12 11
507 CONTSTARTDTE Contract Start Date DATE Date 4 6
508 CONTENDDTE Contract End Date DATE_L Date 4 0
509 CONTITEMNBR Contract Item Number STR30_Item_Number String 32 30
510 CONTSERIALNBR Contract Serial Number STR20_LBAU String 22 20
511 SOPSTATUS SOP Status INT Integer 2 0
512 CUSTPRIORITY Customer Priority DDL_CustomerPriority Integer 2 0
513 ORDERFULFILLDEFAULT Order Fulfillment Shortage Default DDL_OrderFulfillDefault Integer 2 0
514 UMSCHDSC U Of M Schedule Description STR30 String 32 30
515 SHIPCOMPLETE Ship Complete Document CB_ShipComplete Boolean 2 0
516 SHIPCOMPLETE1 ASI_Ship_Complete_Document CB_ShipComplete Boolean 2 0
azurecurveProductsSmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

Leave a Reply

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