ASI SOP Line Item SmartList (ASIEXP20)

azurecurve Products SmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP20

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

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

azurecurve Products SmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

Leave a Reply Cancel reply