SmartList Purchasing Line Items (ASIEXP21)

azurecurve Products SmartList (1493)PathnameSmartList Purchasing Line Items (ASIEXP21)

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

Display Name: SmartList Purchasing Line Items
Physical Name: ASIEXP21
Technical Name: ASI_POP_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	PONUMBER	PO Number	String	STR17_POP_Number	17
3	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
4	ORD	Ord	Long Integer	LI_Sequence_Number	10
5	POLNESTA	PO Line Status	Integer	DDL_PO_Line_Status	0
6	POTYPE	PO Type	Integer	DDL_POP_PO_Type	0
7	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SmartList Purchasing Line Items'].ITEMNMBR AS 'SmartList Purchasing Line Items-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN IV00101 AS ['Item Master'] ON ['SmartList Purchasing Line Items'].ITEMNMBR = ['Item Master'].ITEMNMBR
8	ITEMDESC	Item Description	String	STR100	100
9	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SmartList Purchasing Line Items'].VENDORID AS 'SmartList Purchasing Line Items-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SmartList Purchasing Line Items'].VENDORID = ['PM Vendor Master File'].VENDORID
10	VNDITNUM	Vendor Item Number	String	Item_Number	30
11	VNDITDSC	Vendor Item Description	String	STR100	100
12	NONINVEN	Non IV	Integer	INT1	1
13	UOFM	U Of M	String	U_Of_M	8
14	UMQTYINB	U Of M QTY In Base	Currency	DLR17_QTY_RBS0_STR	17
15	QTYORDER	QTY Ordered	Currency	DLR17_QTY_RBS0_UTR	17
16	QTYCANCE	QTY Canceled	Currency	DLR17_QTY_RBS0_UTR	17
17	QTYCMTBASE	QTY Committed In Base	Currency	DLR17_QTY_RBS0_STR	17
18	QTYUNCMTBASE	QTY Uncommitted In Base	Currency	DLR17_QTY_RBS0_STR	17
19	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
20	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
21	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].INVINDX AS 'SmartList Purchasing Line Items-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].INVINDX = ['Account Index Master'].ACTINDX
22	REQDATE	Required Date	Date	DATE_L	0
23	PRMDATE	Promised Date	Date	DATE_L	0
24	PRMSHPDTE	Promised Ship Date	Date	DATE_L	0
25	REQSTDBY	Requested By	String	STR20_LB	20
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Purchasing Line Items'].REQSTDBY AS 'SmartList Purchasing Line Items-Requested By' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Purchasing Line Items'].REQSTDBY = ['Users Master'].USERID
26	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['SmartList Purchasing Line Items'].COMMNTID AS 'SmartList Purchasing Line Items-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN SY04200 AS ['Comment Master'] ON ['SmartList Purchasing Line Items'].COMMNTID = ['Comment Master'].COMMNTID
27	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
28	POLNEARY_1	PO Line Note ID Array[1]	Currency	DLR14	14
29	POLNEARY_2	PO Line Note ID Array[2]	Currency	DLR14	14
30	POLNEARY_3	PO Line Note ID Array[3]	Currency	DLR14	14
31	POLNEARY_4	PO Line Note ID Array[4]	Currency	DLR14	14
32	POLNEARY_5	PO Line Note ID Array[5]	Currency	DLR14	14
33	POLNEARY_6	PO Line Note ID Array[6]	Currency	DLR14	14
34	POLNEARY_7	PO Line Note ID Array[7]	Currency	DLR14	14
35	POLNEARY_8	PO Line Note ID Array[8]	Currency	DLR14	14
36	POLNEARY_9	PO Line Note ID Array[9]	Currency	DLR14	14
37	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
38	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
39	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
40	BRKFLD1	Break Field 1	Integer	INT1	1
41	PO_Line_Status_Orig	PO Line Status Orig	Integer	DDL_PO_Line_Status	0
42	QTY_Canceled_Orig	QTY Canceled Orig	Currency	DLR17_QTY_RBS0_UTR	17
43	OPOSTSUB	Originating Posted Subtotal	Currency	DLR17_RBS0_STR$	17
44	JOBNUMBR	Job Number	String	STR17_LBAU	17
45	COSTCODE	Cost Code	String	STR27	27
46	COSTTYPE	Cost Code Type	Integer	INT3_RB0_U	3
47	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CURNCYID AS 'SmartList Purchasing Line Items-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Purchasing Line Items'].CURNCYID = ['Currency Setup'].CURNCYID
48	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CURRNIDX AS 'SmartList Purchasing Line Items-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Purchasing Line Items'].CURRNIDX = ['Currency Setup'].CURRNIDX
49	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
50	RATECALC	Rate Calc Method	Integer	INT	0
51	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
52	ORUNTCST	Originating Unit Cost	Currency	DLR17_RBS0_UTR$	17
53	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
54	LINEORIGIN	Line Origin	Integer	DDL_Line_Origin	0
55	FREEONBOARD	Free On Board	Integer	DDL_Free_On_Board	0
56	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
57	Capital_Item	Capital Item	Boolean	CB_Capital_Item	0
58	Product_Indicator	Product Indicator	Integer	DDL_Product_Indicator	0
59	Source_Document_Number	Source Document Number	String	STR11_Document_Number	11
60	Source_Document_Line_Num	Source Document Line Number	Integer	INT4	4
61	ASI_Document_Status	ASI_Document_Status	Integer	INT	0
62	STATGRP	Status Group	Integer	INT1	1
63	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Purchasing Line Items'].USER2ENT AS 'SmartList Purchasing Line Items-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Purchasing Line Items'].USER2ENT = ['Users Master'].USERID
64	CONFIRM1	Confirm With	String	STR20	20
65	DOCDATE	Document Date	Date	DT	8
66	LSTEDTDT	Last Edit Date	Date	DT_Date	6
67	LSTPRTDT	Last Printed Date	Date	DATE_L	0
68	REQTNDT	Requisition Date	Date	DATE_L	0
69	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList Purchasing Line Items'].SHIPMTHD AS 'SmartList Purchasing Line Items-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList Purchasing Line Items'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
70	TXRGNNUM	Tax Registration Number	String	STR25	25
71	REMSUBTO	Remaining Subtotal	Currency	DLR17_RBS0_UTR$	17
72	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
73	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
74	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
75	MSCCHAMT	Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
76	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
77	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
78	MINORDER	Minimum Order	Currency	DLR17_$U2	17
79	VADCDPAD	Vendor Address Code - Purchase Address	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Purchasing Line Items'].VADCDPAD AS 'SmartList Purchasing Line Items-Vendor Address Code - Purchase Address' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Purchasing Line Items'].VADCDPAD = ['PM Address MSTR'].ADRSCODE AND ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
80	CMPANYID	Company ID	Integer	INT5	4
	Key to the Company Master (SY01500). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CMPANYID AS 'SmartList Purchasing Line Items-Company ID' ,['Company Master'].CMPANYID AS 'Company Master-Company ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['SmartList Purchasing Line Items'].CMPANYID = ['Company Master'].CMPANYID
81	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
82	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
83	CMPNYNAM	Company Name	String	STR64_Company_Name	64
84	CONTACT	Contact	String	STR60	60
85	ADDRESS1	Address 1	String	STR60	60
86	ADDRESS2	Address 2	String	STR60	60
87	ADDRESS3	Address 3	String	STR60	60
88	CITY	City	String	STR35	35
89	STATE	State	String	STR30_State	29
90	ZIPCODE	Zip Code	String	STR10	10
91	COUNTRY	Country	String	STR60	60
92	PHONE1	Phone 1	String	Phone_Number	14
93	PHONE2	Phone 2	String	Phone_Number	14
94	FAX	Fax	String	STR14_FAX	14
95	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PYMTRMID AS 'SmartList Purchasing Line Items-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList Purchasing Line Items'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
96	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
97	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
98	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
99	DISCDATE	Discount Date	Date	DT	8
100	DUEDATE	Due Date	Date	DT	8
101	TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	Trade Discount Percent (Precise)	23
102	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CUSTNMBR AS 'SmartList Purchasing Line Items-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SmartList Purchasing Line Items'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
103	TIMESPRT	Times Printed	Integer	INT4_U0	4
104	CREATDDT	Created Date	Date	DT	8
105	MODIFDT	Modified Date	Date	DT	8
106	PONOTIDS_1	PO Note ID Array[1]	Currency	DLR14	14
107	PONOTIDS_2	PO Note ID Array[2]	Currency	DLR14	14
108	PONOTIDS_3	PO Note ID Array[3]	Currency	DLR14	14
109	PONOTIDS_4	PO Note ID Array[4]	Currency	DLR14	14
110	PONOTIDS_5	PO Note ID Array[5]	Currency	DLR14	14
111	PONOTIDS_6	PO Note ID Array[6]	Currency	DLR14	14
112	PONOTIDS_7	PO Note ID Array[7]	Currency	DLR14	14
113	PONOTIDS_8	PO Note ID Array[8]	Currency	DLR14	14
114	PONOTIDS_9	PO Note ID Array[9]	Currency	DLR14	14
115	PONOTIDS_10	PO Note ID Array[10]	Currency	DLR14	14
116	PONOTIDS_11	PO Note ID Array[11]	Currency	DLR14	14
117	PONOTIDS_12	PO Note ID Array[12]	Currency	DLR14	14
118	PONOTIDS_13	PO Note ID Array[13]	Currency	DLR14	14
119	PONOTIDS_14	PO Note ID Array[14]	Currency	DLR14	14
120	PONOTIDS_15	PO Note ID Array[15]	Currency	DLR14	14
121	COMMENT_1	Comment[1]	String	STR50	50
122	COMMENT_2	Comment[2]	String	STR50	50
123	COMMENT_3	Comment[3]	String	STR50	50
124	COMMENT_4	Comment[4]	String	STR50	50
125	CANCSUB	Canceled Subtotal	Currency	DLR17_RBS0_STR$	17
126	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SmartList Purchasing Line Items'].RATETPID AS 'SmartList Purchasing Line Items-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList Purchasing Line Items'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
127	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['SmartList Purchasing Line Items'].EXGTBLID AS 'SmartList Purchasing Line Items-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['SmartList Purchasing Line Items'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
128	EXCHDATE	Exchange Date	Date	DT_Date	6
129	TIME1	Time	Time	TM6	6
130	MCTRXSTT	MC Transaction State	Integer	INT1	1
131	OREMSUBT	Originating Remaining Subtotal	Currency	DLR17_RBS0_UTR$	17
132	ORSUBTOT	Originating Subtotal	Currency	DLR17_RBS0_STR$	17
133	Originating_Canceled_Sub	Originating Canceled Subtotal	Currency	DLR17_RBS0_STR$	17
134	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
135	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
136	OMISCAMT	Originating Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
137	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
138	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
139	ODISAMTAV	Originating Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
140	BUYERID	Buyer ID	String	STR15_User_ID	15
141	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
142	ORORDAMT	Originating On Order Amount	Currency	DLR19_RBS0_UTR$	19
143	HOLD	Hold	Boolean	CB_Hold	0
144	ONHOLDDATE	On Hold Date	Date	DT	8
145	ONHOLDBY	On Hold By	String	STR15_User_ID	15
146	HOLDREMOVEDATE	Hold Remove Date	Date	DT	8
147	HOLDREMOVEBY	Hold Remove By	String	STR15_User_ID	15
148	ALLOWSOCMTS	Allow SO Commitments	Boolean	CB_AllowSOCommitments	0
149	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Purchasing Line Items'].NOTEINDX AS 'SmartList Purchasing Line Items-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Purchasing Line Items'].NOTEINDX = ['Record Notes Master'].NOTEINDX
150	ITMSHNAM	Item Short Name	String	STR15	15
151	ITEMTYPE	Item Type	Integer	DDL_Item_Type	0
152	ITMGEDSC	Item Generic Description	String	STR10	10
153	STNDCOST	Standard Cost	Currency	DLR17_RBS0_UTR$	17
154	CURRCOST	Current Cost	Currency	DLR17_RBS0_UTR$	17
155	LISTPRCE	List Price	Currency	DLR17_RBS0_STR$	17
156	ITEMSHWT	Item Shipping Weight	Long Integer	LI6_RBS2_UT	6
157	ITMTSHID	Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Purchasing Line Items'].ITMTSHID AS 'SmartList Purchasing Line Items-Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Line Items'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
158	TAXOPTNS	Tax Options	Integer	DDL_Tax_Options	0
159	COMMCODE	Commission Code	String	STR15_LBAU	15
160	IVIVINDX	IV IV Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVIVINDX AS 'SmartList Purchasing Line Items-IV IV Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVIVINDX = ['Account Index Master'].ACTINDX
161	IVIVOFIX	IV IV Offset Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVIVOFIX AS 'SmartList Purchasing Line Items-IV IV Offset Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVIVOFIX = ['Account Index Master'].ACTINDX
162	IVCOGSIX	IV COGS Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVCOGSIX AS 'SmartList Purchasing Line Items-IV COGS Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVCOGSIX = ['Account Index Master'].ACTINDX
163	IVSLSIDX	IV Sales Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVSLSIDX AS 'SmartList Purchasing Line Items-IV Sales Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVSLSIDX = ['Account Index Master'].ACTINDX
164	IVSLDSIX	IV Sales Discounts Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVSLDSIX AS 'SmartList Purchasing Line Items-IV Sales Discounts Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVSLDSIX = ['Account Index Master'].ACTINDX
165	IVSLRNIX	IV Sales Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVSLRNIX AS 'SmartList Purchasing Line Items-IV Sales Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVSLRNIX = ['Account Index Master'].ACTINDX
166	IVINUSIX	IV In Use Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVINUSIX AS 'SmartList Purchasing Line Items-IV In Use Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVINUSIX = ['Account Index Master'].ACTINDX
167	IVINSVIX	IV In Service Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVINSVIX AS 'SmartList Purchasing Line Items-IV In Service Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVINSVIX = ['Account Index Master'].ACTINDX
168	IVDMGIDX	IV Damaged Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVDMGIDX AS 'SmartList Purchasing Line Items-IV Damaged Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVDMGIDX = ['Account Index Master'].ACTINDX
169	IVVARIDX	IV Variances Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVVARIDX AS 'SmartList Purchasing Line Items-IV Variances Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVVARIDX = ['Account Index Master'].ACTINDX
170	DPSHPIDX	Drop Ship Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].DPSHPIDX AS 'SmartList Purchasing Line Items-Drop Ship Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].DPSHPIDX = ['Account Index Master'].ACTINDX
171	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PURPVIDX AS 'SmartList Purchasing Line Items-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PURPVIDX = ['Account Index Master'].ACTINDX
172	IVRETIDX	Inventory Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVRETIDX AS 'SmartList Purchasing Line Items-Inventory Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVRETIDX = ['Account Index Master'].ACTINDX
173	ASMVRIDX	Assembly Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].ASMVRIDX AS 'SmartList Purchasing Line Items-Assembly Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].ASMVRIDX = ['Account Index Master'].ACTINDX
174	ITMCLSCD	Item Class Code	String	STR10_Class_ID	10
	Key to the Item Class Setup (IV40400). Click to show/hide SELECT ['SmartList Purchasing Line Items'].ITMCLSCD AS 'SmartList Purchasing Line Items-Item Class Code' ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN IV40400 AS ['Item Class Setup'] ON ['SmartList Purchasing Line Items'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
175	LOTTYPE	Lot Type	String	STR10_Lot_Type	10
176	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
177	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
178	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
179	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
180	ALWBKORD	Allow Back Orders	Boolean	CB_Allow_Back_Orders	0
181	VCTNMTHD	Valuation Method	Integer	DDL_Valuation_Method	0
182	UOMSCHDL	U Of M Schedule	String	STR10_Schedule	10
	Key to the Inventory U of M Schedule Setup (IV40201). Click to show/hide SELECT ['SmartList Purchasing Line Items'].UOMSCHDL AS 'SmartList Purchasing Line Items-U Of M Schedule' ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN IV40201 AS ['Inventory U of M Schedule Setup'] ON ['SmartList Purchasing Line Items'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
183	ALTITEM1	Alternate Item 1	String	STR30_Item_Number	30
184	ALTITEM2	Alternate Item 2	String	STR30_Item_Number	30
185	USCATVLS_1	User Category Values[1]	String	User_Category_Value	10
186	USCATVLS_2	User Category Values[2]	String	User_Category_Value	10
187	USCATVLS_3	User Category Values[3]	String	User_Category_Value	10
188	USCATVLS_4	User Category Values[4]	String	User_Category_Value	10
189	USCATVLS_5	User Category Values[5]	String	User_Category_Value	10
190	USCATVLS_6	User Category Values[6]	String	User_Category_Value	10
191	MSTRCDTY	Master Record Type	Integer	INT1	1
192	WRNTYDYS	Warranty Days	Integer	INT4	4
193	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
194	VNDCHKNM	Vendor Check Name	String	STR64_Vendor_Name	64
195	VENDSHNM	Vendor Short Name	String	STR15	15
196	VADDCDPR	Vendor Address Code - Primary	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Purchasing Line Items'].VADDCDPR AS 'SmartList Purchasing Line Items-Vendor Address Code - Primary' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Purchasing Line Items'].VADDCDPR = ['PM Address MSTR'].ADRSCODE AND ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
197	VADCDSFR	Vendor Address Code - Ship From	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Purchasing Line Items'].VADCDSFR AS 'SmartList Purchasing Line Items-Vendor Address Code - Ship From' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Purchasing Line Items'].VADCDSFR = ['PM Address MSTR'].ADRSCODE AND ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
198	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Purchasing Line Items'].VADCDTRO AS 'SmartList Purchasing Line Items-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Purchasing Line Items'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
199	VNDCLSID	Vendor Class ID	String	STR10_Class_ID	10
	Key to the PM Class Master File (PM00100). Click to show/hide SELECT ['SmartList Purchasing Line Items'].VNDCLSID AS 'SmartList Purchasing Line Items-Vendor Class ID' ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN PM00100 AS ['PM Class Master File'] ON ['SmartList Purchasing Line Items'].VNDCLSID = ['PM Class Master File'].VNDCLSID
200	VNDCNTCT	Vendor Contact	String	STR60	60
201	UPSZONE	UPS Zone	String	STR3	3
202	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 ['SmartList Purchasing Line Items'].TAXSCHID AS 'SmartList Purchasing Line Items-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Line Items'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
203	ACNMVNDR	Account Number With Vendor	String	STR20	20
204	TXIDNMBR	Tax ID Number	String	Tax_ID_Number	11
205	VENDSTTS	Vendor Status	Integer	DDL_Vendor_Status	0
206	PARVENID	Parent Vendor ID	String	STR_15_Vendor_ID	15
207	TRDDISCT	Trade Discount	Integer	INT4_%2	4
208	TEN99TYPE	1099 Type	Integer	1099_Type	0
209	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
210	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
211	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
212	MXIAFVND	Maximum Invoice Amount For Vendors	Integer	GB	0
213	MAXINDLR	Maximum Invoice Dollar	Currency	DLR17_$U2	17
214	COMMENT1	Comment1	String	STR30	30
215	COMMENT2	Comment2	String	STR30	30
216	USERDEF1	User Defined 1	String	STR20	20
217	USERDEF2	User Defined 2	String	STR20	20
218	CRLMTDLR	Credit Limit Dollar	Currency	DLR17_$U2	17
219	PYMNTPRI	Payment Priority	String	STR3	3
220	KGLDSTHS	Keep GL Dist History	Boolean	CB_Keep_GL_Dist_History	0
221	PTCSHACF	Post To Cash Account From	Integer	GB	0
222	CREDTLMT	Credit Limit	Integer	GB	0
223	WRITEOFF	Writeoff	Integer	GB	0
224	MXWOFAMT	Maximum Write Off Amount	Currency	DLR17_$U2	17
225	SBPPSDED	Subject To PPS Deductions	Boolean	CB_Subject_To_PPS_Deductions	0
226	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
227	DXVARNUM	Deduction Exemption/Variation Number	String	STR25	25
228	CRTCOMDT	Certificate Commencing Date	Date	DT	8
229	CRTEXPDT	Certificate Expiration Date	Date	DT	8
230	RTOBUTKN	Reporting Obligation Undertaken	Boolean	CB_Reporting_Obligation	0
231	XPDTOBLG	Expiration Date Obligation	Boolean	CB_Expiration_Date_Obligation	0
232	PRSPAYEE	Prescribed Payee	Boolean	CB_Prescribed_Payee	0
233	PMAPINDX	PM AP Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMAPINDX AS 'SmartList Purchasing Line Items-PM AP Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMAPINDX = ['Account Index Master'].ACTINDX
234	PMCSHIDX	PM Cash Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMCSHIDX AS 'SmartList Purchasing Line Items-PM Cash Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMCSHIDX = ['Account Index Master'].ACTINDX
235	PMDAVIDX	PM Discount Available Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMDAVIDX AS 'SmartList Purchasing Line Items-PM Discount Available Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMDAVIDX = ['Account Index Master'].ACTINDX
236	PMDTKIDX	PM Discount Taken Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMDTKIDX AS 'SmartList Purchasing Line Items-PM Discount Taken Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMDTKIDX = ['Account Index Master'].ACTINDX
237	PMFINIDX	PM Finance Charge Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMFINIDX AS 'SmartList Purchasing Line Items-PM Finance Charge Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMFINIDX = ['Account Index Master'].ACTINDX
238	PMMSCHIX	PM Misc Charges Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMMSCHIX AS 'SmartList Purchasing Line Items-PM Misc Charges Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMMSCHIX = ['Account Index Master'].ACTINDX
239	PMFRTIDX	PM Freight Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMFRTIDX AS 'SmartList Purchasing Line Items-PM Freight Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMFRTIDX = ['Account Index Master'].ACTINDX
240	PMTAXIDX	PM Tax Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMTAXIDX AS 'SmartList Purchasing Line Items-PM Tax Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMTAXIDX = ['Account Index Master'].ACTINDX
241	PMWRTIDX	PM Write Offs Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMWRTIDX AS 'SmartList Purchasing Line Items-PM Write Offs Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMWRTIDX = ['Account Index Master'].ACTINDX
242	PMPRCHIX	PM Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMPRCHIX AS 'SmartList Purchasing Line Items-PM Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMPRCHIX = ['Account Index Master'].ACTINDX
243	PMRTNGIX	PM Retainage Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMRTNGIX AS 'SmartList Purchasing Line Items-PM Retainage Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMRTNGIX = ['Account Index Master'].ACTINDX
244	PMTDSCIX	PM Trade Discount Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PMTDSCIX AS 'SmartList Purchasing Line Items-PM Trade Discount Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PMTDSCIX = ['Account Index Master'].ACTINDX
245	ACPURIDX	Accrued Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].ACPURIDX AS 'SmartList Purchasing Line Items-Accrued Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].ACPURIDX = ['Account Index Master'].ACTINDX
246	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CHEKBKID AS 'SmartList Purchasing Line Items-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList Purchasing Line Items'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
247	Revalue_Vendor	Revalue Vendor	Boolean	CB Revalue Vendor	0
248	Post_Results_To	Post Results To	Integer	GB	0
249	POSTATUS	PO Status	Integer	DDL_PO_Status	0
250	HIESTBAL	Highest Balance	Currency	DLR17_RBS0_UTR$	17
251	CURRBLNC	Current Balance	Currency	DLR19_RBS0_STR$	19
252	NOINVYTD	Number of Invoices YTD	Long Integer	LI_9U0	9
253	NOINVLIF	Number of Invoices LIFE	Long Integer	LI_9U0	9
254	NOINVLYR	Number of Invoices LYR	Long Integer	LI_9U0	9
255	NOPINYTD	Number of Paid Invoices YTD	Long Integer	LI_9U0	9
256	NOPILIFE	Number of Paid Invoices LIFE	Long Integer	LI_9U0	9
257	AMBLDTYD	Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
258	AMBLDLIF	Amount Billed LIFE	Currency	DLR19_RBS0_STR$	19
259	AMBLDLYR	Amount Billed LYR	Currency	DLR19_RBS0_STR$	19
260	AMTPDYTD	Amount Paid YTD	Currency	DLR19_RBS0_STR$	19
261	AMTPDLIF	Amount Paid LIFE	Currency	DLR19_RBS0_STR$	19
262	AMTPDLYR	Amount Paid LYR	Currency	DLR19_RBS0_STR$	19
263	TEN99AYTD	1099 Amount YTD	Currency	DLR19_RBS0_STR$	19
264	TEN99ALIF	1099 Amount LIFE	Currency	DLR19_RBS0_STR$	19
265	TEN99ALYR	1099 Amount LYR	Currency	DLR19_RBS0_STR$	19
266	DISAVYTD	Discount Available YTD	Currency	DLR19_RBS0_STR$	19
267	DISAVLIF	Discount Available LIFE	Currency	DLR19_RBS0_STR$	19
268	DISAVLYR	Discount Available LYR	Currency	DLR19_RBS0_STR$	19
269	DISTKYTD	Discount Taken YTD	Currency	DLR19_RBS0_STR$	19
270	DISTKNLF	Discount Taken LIFE	Currency	DLR19_RBS0_STR$	19
271	DISTKLYR	Discount Taken LYR	Currency	DLR19_RBS0_STR$	19
272	DISLSYTD	Discount Lost YTD	Currency	DLR19_RBS0_STR$	19
273	DISLSTLF	Discount Lost LIFE	Currency	DLR19_RBS0_STR$	19
274	DISLSLYR	Discount Lost LYR	Currency	DLR19_RBS0_STR$	19
275	FINCHLIF	Finance Charge LIFE	Currency	DLR19_RBS0_STR$	19
276	FINCHLYR	Finance Charge LYR	Currency	DLR19_RBS0_STR$	19
277	FINCHYTD	Finance Charge YTD	Currency	DLR19_RBS0_STR$	19
278	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
279	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
280	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
281	RTRNSYTD	Returns YTD	Currency	DLR19_RBS0_STR$	19
282	RTRNSLIF	Returns LIFE	Currency	DLR19_RBS0_STR$	19
283	RTRNSLYR	Returns LYR	Currency	DLR19_RBS0_STR$	19
284	TRDTKLIF	Trade Discounts Taken LIFE	Currency	DLR19_RBSO_STR$	19
285	TRDTLYR	Trade Discounts Taken LYR	Currency	DLR19_RBSO_STR$	19
286	TRDTYTD	Trade Discounts Taken YTD	Currency	DLR19_RBSO_STR$	19
287	NFNCHLIF	Number of Finance Charges LIFE	Long Integer	LI_9U0	9
288	NFNCHLYR	Number of Finance Charges LYR	Long Integer	LI_9U0	9
289	NFNCHYTD	Number of Finance Charges YTD	Long Integer	LI_9U0	9
290	RTNGOWED	Retainage Owed	Currency	DLR17_RBS0_STR$	17
291	LSTCHNUM	Last Check Number	String	Check_Number	20
292	LSTCHKDT	Last Check Date	Date	DT	8
293	LSTCHAMT	Last Check Amount	Currency	DLR17_RBS0_UTR$	17
294	LSTINNUM	Last Invoice Number	String	STR20	20
295	LSTINVAM	Last Invoice Amount	Currency	DLR17_RBS0_UTR$	17
296	LSTPURDT	Last Purchase Date	Date	DT	8
297	FSTPURDT	First Purchase Date	Date	DT	8
298	CURUNPBN	Current Unapplied Payment Balance	Currency	DLR17_RBS0_UTR$	17
299	UNPDFNCH	Unpaid Finance Charges	Currency	DLR17_RBS0_UTR$	17
300	DYCHTCLR	Days Checks To Clear	Integer	INT3_U0	3
301	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
302	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
303	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
304	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
305	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
306	CNTCPRSN	Contact Person	String	STR60	60
307	STMTNAME	Statement Name	String	STR64	64
308	SHRTNAME	Short Name	String	STR15	15
309	ADRSCODE	Address Code	String	STR15_Address_Code	15
310	STADDRCD	Statement Address Code	String	STR15_LBAU	15
311	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SmartList Purchasing Line Items'].SLPRSNID AS 'SmartList Purchasing Line Items-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SmartList Purchasing Line Items'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
312	CRLMTTYP	Credit Limit Type	Integer	GB_Amt_Type	0
313	CRLMTAMT	Credit Limit Amount	Currency	DLR17_RBS0_UTR$	17
314	CRLMTPER	Credit Limit Period	Integer	DDL	0
315	CRLMTPAM	Credit Limit Period Amount	Currency	DLR17_RBS0_UTR$	17
316	CUSTDISC	Customer Discount	Integer	INT5_%2	5
317	FNCHATYP	Finance Charge Amt Type	Integer	GB_Amt_Type	0
318	FNCHPCNT	Finance Charge Percent	Integer	INT5_%2	5
319	FINCHDLR	Finance Charge Dollar	Currency	DLR17_RBS0_UTR$	17
320	MXWOFTYP	Maximum Writeoff Type	Integer	GP_Max_Writeoff	0
321	MXWROFAM	Max Writeoff Amount	Currency	DLR17_RBS0_UTR$	17
322	TAXEXMT1	Tax Exempt 1	String	STR25	25
323	TAXEXMT2	Tax Exempt 2	String	STR25	25
324	BALNCTYP	Balance Type	Integer	GB_Bal_Type	0
325	STMTCYCL	Statement Cycle	Integer	DDL_Stmt_Cycle	0
326	BANKNAME	Bank Name	String	STR30	30
327	BNKBRNCH	Bank Branch	String	STR20	20
328	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SmartList Purchasing Line Items'].SALSTERR AS 'SmartList Purchasing Line Items-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SmartList Purchasing Line Items'].SALSTERR = ['Sales Territory Master File'].SALSTERR
329	DEFCACTY	Default Cash Account Type	Integer	GB	0
330	RMCSHACC	RM Cash Account Index	Long Integer	LI_14	14
331	RMARACC	RM AR Account Index	Long Integer	LI_14	14
332	RMSLSACC	RM Sales Account Index	Long Integer	LI_14	14
333	RMIVACC	RM IV Account Index	Long Integer	LI_14	14
334	RMCOSACC	RM Cost Of Sales Account Index	Long Integer	LI_14	14
335	RMTAKACC	RM Discounts Taken Account Index	Long Integer	LI_14	14
336	RMAVACC	RM Discounts Avail Account Index	Long Integer	LI_14	14
337	RMFCGACC	RM Finance Charge Account Index	Long Integer	LI_14	14
338	RMWRACC	RM Writeoff Account Index	Long Integer	LI_14	14
339	FRSTINDT	First Invoice Date	Date	DT_Date	6
340	INACTIVE	Inactive	Boolean	CB_Inactive	0
341	CRCARDID	Credit Card ID	String	STR15	15
342	CRCRDNUM	Credit Card Number	String	STR20	20
343	CCRDXPDT	Credit Card Exp Date	Date	DT_Date	6
344	Revalue_Customer	Revalue Customer	Boolean	CB Revalue Customer	0
345	FINCHID	Finance Charge ID	String	STR15_Charge_ID	15
346	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
347	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
348	TNSFCLIF	Total Amount Of NSF Checks Life	Currency	DLR19_RBS0_STR$	19
349	NONSFLIF	Number Of NSF Checks Life	Long Integer	LI6_U0	6
350	CUSTBLNC	Customer Balance	Currency	DLR19_RBS0_STR$	19
351	AGPERAMT_1	Aging Period Amounts[1]	Currency	DLR17_RBSO_STR$	17
352	AGPERAMT_2	Aging Period Amounts[2]	Currency	DLR17_RBSO_STR$	17
353	AGPERAMT_3	Aging Period Amounts[3]	Currency	DLR17_RBSO_STR$	17
354	AGPERAMT_4	Aging Period Amounts[4]	Currency	DLR17_RBSO_STR$	17
355	AGPERAMT_5	Aging Period Amounts[5]	Currency	DLR17_RBSO_STR$	17
356	AGPERAMT_6	Aging Period Amounts[6]	Currency	DLR17_RBSO_STR$	17
357	AGPERAMT_7	Aging Period Amounts[7]	Currency	DLR17_RBSO_STR$	17
358	LASTAGED	Last Aged	Date	DATE	6
359	LSTNSFCD	Last NSF Check Date	Date	DT_Date	6
360	LPYMTAMT	Last Payment Amount	Currency	DLR17_RBS0_STR$	17
361	LASTPYDT	Last Payment Date	Date	DT_Date	6
362	LSTTRXDT	Last Transaction Date	Date	DT_Date	6
363	LSTTRXAM	Last Transaction Amount	Currency	DLR17_RBS0_STR$	17
364	LSTFCHAM	Last Finance Charge Amount	Currency	DLR19_RBS0_STR$	19
365	UPFCHYTD	Unpaid Finance Charges YTD	Currency	DLR17_RBS0_UTR$	17
366	NUMADTPL	Number ADTP Documents - Life	Long Integer	Long_10U	10
367	NUMADTPR	Number ADTP Documents - LYR	Long Integer	Long_10U	10
368	NUMADTPY	Number ADTP Documents - Year	Long Integer	Long_10U	10
369	TDTKNLTD	Total Discounts Taken LTD	Currency	DLR19_RBS0_STR$	19
370	TDTKNLYR	Total Discounts Taken LYR	Currency	DLR19_RBS0_STR$	19
371	TDTKNYTD	Total Discounts Taken YTD	Currency	DLR19_RBS0_STR$	19
372	TDISAYTD	Total Discounts Available YTD	Currency	DLR19_RBS0_STR$	19
373	RETAINAG	Retainage	Currency	DLR19_RBS0_STR$	19
374	TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	DLR19_RBS0_STR$	19
375	NONSFYTD	Number Of NSF Checks YTD	Long Integer	LI6_U0	6
376	UNPSTDSA	Unposted Sales Amount	Currency	DLR19_RBS0_UTR$	19
377	UNPSTDCA	Unposted Cash Amount	Currency	DLR19_RBS0_UTR$	19
378	UNPSTOSA	Unposted Other Sales Amount	Currency	DLR19_RBS0_UTR$	19
379	UNPSTOCA	Unposted Other Cash Amount	Currency	DLR19_RBS0_UTR$	19
380	NCSCHPMT	Non Current Scheduled Payments	Currency	DLR19_RBS0_STR$	19
381	TTLSLLTD	Total Sales LTD	Currency	DLR19_RBS0_STR$	19
382	TTLSLLYR	Total Sales LYR	Currency	DLR19_RBS0_STR$	19
383	TTLSLYTD	Total Sales YTD	Currency	DLR19_RBS0_STR$	19
384	TCOSTLTD	Total Costs LTD	Currency	DLR19_RBS0_STR$	19
385	TCOSTLYR	Total Costs LYR	Currency	DLR19_RBS0_STR$	19
386	TCOSTYTD	Total Costs YTD	Currency	DLR19_RBS0_STR$	19
387	TCSHRLTD	Total Cash Received LTD	Currency	DLR19_RBS0_STR$	19
388	TCSHRLYR	Total Cash Received LYR	Currency	DLR19_RBS0_STR$	19
389	TCSHRYTD	Total Cash Received YTD	Currency	DLR19_RBS0_STR$	19
390	TFNCHLTD	Total Finance Charges LTD	Currency	DLR19_RBS0_STR$	19
391	TFNCHLYR	Total Finance Charges LYR	Currency	DLR19_RBS0_STR$	19
392	TFNCHYTD	Total Finance Charges YTD	Currency	DLR19_RBS0_STR$	19
393	FNCHCYTD	Finance Charges CYTD	Currency	DLR19_RBS0_STR$	19
394	FNCHLYRC	Finance Charges LYR Calendar	Currency	DLR19_RBS0_STR$	19
395	TBDDTLYR	Total Bad Deb LYR	Currency	DLR19_RBS0_STR$	19
396	TBDDTLTD	Total Bad Debt LTD	Currency	DLR19_RBS0_STR$	19
397	TBDDTYTD	Total Bad Debt YTD	Currency	DLR19_RBS0_STR$	19
398	TWVFCLTD	Total Waived FC LTD	Currency	DLR19_RBS0_STR$	19
399	TWVFCLYR	Total Waived FC LYR	Currency	DLR19_RBS0_STR$	19
400	TWVFCYTD	Total Waived FC YTD	Currency	DLR19_RBS0_STR$	19
401	TWROFLTD	Total Writeoffs LTD	Currency	DLR19_RBS0_STR$	19
402	TWROFLYR	Total Writeoffs LYR	Currency	DLR19_RBS0_STR$	19
403	TWROFYTD	Total Writeoffs YTD	Currency	DLR19_RBS0_STR$	19
404	TTLINLTD	Total # Invoices LTD	Long Integer	LI6_U0	6
405	TTLINLYR	Total # Invoices LYR	Long Integer	LI6_U0	6
406	TTLINYTD	Total # Invoices YTD	Long Integer	LI6_U0	6
407	TTLFCLTD	Total # FC LTD	Long Integer	LI6_U0	6
408	TTLFCLYR	Total # FC LYR	Long Integer	LI6_U0	6
409	TTLFCYTD	Total # FC YTD	Long Integer	LI6_U0	6
410	HIBALLTD	High Balance LTD	Currency	DLR19_RBSO_STR$	19
411	HIBALLYR	High Balance LYR	Currency	DLR19_RBSO_STR$	19
412	HIBALYTD	High Balance YTD	Currency	DLR19_RBSO_STR$	19
413	LASTSTDT	Last Statement Date	Date	DATE	6
414	LSTSTAMT	Last Statement Amount	Currency	DLR17_RBS0_STR$	17
415	DEPRECV	Deposits Received	Currency	DLR19_RBS0_STR$	19
416	ABCCODE	ABC Code	Integer	DDL_ABC_Code	0
417	CGSINFLX	COGS Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CGSINFLX AS 'SmartList Purchasing Line Items-COGS Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].CGSINFLX = ['Account Index Master'].ACTINDX
418	CGSMCIDX	COGS Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].CGSMCIDX AS 'SmartList Purchasing Line Items-COGS Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].CGSMCIDX = ['Account Index Master'].ACTINDX
419	IVINFIDX	Inventory Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].IVINFIDX AS 'SmartList Purchasing Line Items-Inventory Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].IVINFIDX = ['Account Index Master'].ACTINDX
420	INVMCIDX	Inventory Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].INVMCIDX AS 'SmartList Purchasing Line Items-Inventory Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].INVMCIDX = ['Account Index Master'].ACTINDX
421	ITEMCODE	Item Code	String	STR15	15
422	KTACCTSR	Kit COGS Account Source	Integer	GB	0
423	LASTGENSN	Last Generated Serial Number	String	STR20_LBAU	20
424	PriceGroup	Price Group	String	STR10_LBAU	10
425	PRICMTHD	Price Method	Integer	DDL_Price_Method	0
426	PINFLIDX	Purch Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PINFLIDX AS 'SmartList Purchasing Line Items-Purch Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PINFLIDX = ['Account Index Master'].ACTINDX
427	PURMCIDX	Purch Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].PURMCIDX AS 'SmartList Purchasing Line Items-Purch Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].PURMCIDX = ['Account Index Master'].ACTINDX
428	PRCHSUOM	Purchasing U Of M	String	U_Of_M	8
429	SELNGUOM	Selling U Of M	String	U_Of_M	8
430	TCC	Tax Commodity Code	String	STR30_VAT	30
431	UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Line Items'].UPPVIDX AS 'SmartList Purchasing Line Items-Unrealized Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Line Items'].UPPVIDX = ['Account Index Master'].ACTINDX
432	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
433	DOCFMTID	Document Format ID	String	STR15_LBU	15
434	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
435	PHONE3	Phone 3	String	Phone_Number3	14
436	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
437	Withholding_LIFE	Withholding LIFE	Currency	DLR19_RBS0_STR$	19
438	WITHLYR	Withholding LYR	Currency	DLR19_RBS0_STR$	19
439	WITHYTD	Withholding YTD	Currency	DLR19_RBS0_STR$	19
440	Change_Order_Flag	Change Order Flag	Integer	INT	0
441	PO_Field_Changes	PO Field Changes	Long Integer	ML_POP_PO_Field_Changes	0
442	PO_Status_Orig	PO Status Orig	Integer	DDL_PO_Status	0
443	Revision_Number	Revision Number	Integer	INT4	4
444	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SmartList Purchasing Line Items'].LOCNCODE AS 'SmartList Purchasing Line Items-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SmartList Purchasing Line Items'].LOCNCODE = ['Site Setup'].LOCNCODE
445	RELEASEBYDATE	Release By Date	Date	DATE_L	0
446	Released_Date	Released Date	Date	DATE_L	0
447	UPSZONE1	ASI_UPS_Zone	String	STR3	3
448	SHIPMTHD1	ASI_Shipping_Method	String	STR15_Shipping_Method	15
449	TAXSCHID1	ASI_Tax_Schedule_ID	String	STR15_Tax_Schedule_ID	15
450	ADDRESS11	ASI_Address_1	String	STR60	60
451	ADDRESS21	ASI_Address_2	String	STR60	60
452	ADDRESS31	ASI_Address_3	String	STR60	60
453	CITY1	ASI_City	String	STR35	35
454	STATE1	ASI_State	String	STR30_State	29
455	COUNTRY1	ASI_Country	String	STR60	60
456	ZIP1	ASI_Zip	String	STR10	10
457	PHONE11	ASI_Phone_1	String	Phone_Number	14
458	PHONE21	ASI_Phone_2	String	Phone_Number	14
459	FAX1	ASI_Fax	String	STR14_FAX	14
460	PRBTADCD1	ASI_Primary_Billto_Address_Code	String	STR15_LBAU	15
461	PRSTADCD1	ASI_Primary_Shipto_Address_Code	String	STR15_LBAU	15
462	CHEKBKID1	ASI_Checkbook_ID	String	STR15_Checkbook_ID	15
463	PYMTRMID1	ASI_Payment_Terms_ID	String	STR20_Payment_Terms_ID	20
464	CURNCYID1	ASI_Currency_ID	String	STR15_Currency_ID	15
465	RATETPID1	ASI_Rate_Type_ID	String	STR15_Rate_Type_ID	15
466	ASI_Minimum_Payment_Type	ASI_Minimum_Payment_Type	Integer	ASI_Minimum_Payment_Type	0
467	MINPYDLR1	ASI_Minimum_Payment_Dollar	Currency	DLR17_RBS0_UTR$	17
468	MINPYPCT1	ASI_Minimum_Payment_Percent	Integer	INT5_%2	5
469	COMMENT11	ASI_Comment1	String	STR30	30
470	COMMENT21	ASI_Comment2	String	STR30	30
471	USERDEF11	ASI_User_Defined_1	String	STR20	20
472	USERDEF21	ASI_User_Defined_2	String	STR20	20
473	TXRGNNUM1	ASI_Tax_Registration_Number	String	STR25	25
474	HOLD1	ASI_Hold	Boolean	CB_Hold	0
475	KPDSTHST1	ASI_Keep_Distribution_History	Boolean	CB_Keep_Dist_History	0
476	KPCALHST1	ASI_Keep_Calendar_History	Boolean	CB_Keep_Calendar_History	0
477	KPERHIST1	ASI_Keep_Period_History	Boolean	CB_Keep_Period_History	0
478	KPTRXHST1	ASI_Keep_Trx_History	Boolean	CB_Keep_Trx_History	0
479	NOTEINDX1	ASI_Note_Index	Currency	DLR14	14
480	CREATDDT1	ASI_Created_Date	Date	DT	8
481	MODIFDT1	ASI_Modified_Date	Date	DT	8
482	FRSTINDT1	ASI_First_Invoice_Date	Date	DT_Date	6
483	AVDTPLIF1	ASI_Average_Days_To_Pay_Life	Integer	INT3_U0	3
484	AVDTPLYR1	ASI_Average_Days_to_Pay_LYR	Integer	INT3_U0	3
485	AVGDTPYR1	ASI_Average_Days_To_Pay_Year	Integer	INT3_U0	3
486	WROFSLIF1	ASI_Write_Offs_LIFE	Currency	DLR19_RBS0_STR$	19
487	WROFSLYR1	ASI_Write_Offs_LYR	Currency	DLR19_RBS0_STR$	19
488	WROFSYTD1	ASI_Write_Offs_YTD	Currency	DLR19_RBS0_STR$	19
489	ONORDAMT1	ASI_On_Order_Amount	Currency	DLR19_RBS0_UTR$	19
490	ASI_Post_Results_To	ASI_Post_Results_To	Integer	ASI_Post_Results_To	0
491	DISGRPER1	ASI_Discount_Grace_Period	Integer	INT2_U0	2
492	DOCFMTID1	ASI_Document_Format_ID	String	STR15_LBU	15
493	DUEGRPER1	ASI_Due_Date_Grace_Period	Integer	INT2_U0	2
494	PHONE31	ASI_Phone_3	String	Phone_Number	14
495	ITEMDESC1	ASI_Item_Description	String	STR50	50
496	NOTEINDX11	ASI_Note_Index2	Currency	DLR14	14
497	DECPLQTY1	ASI_Decimal_Places_QTYS	Integer	DDL_Decimal_Places_QTYS	0
498	DECPLCUR1	ASI_Decimal_Places_Currency	Integer	DDL_Decimal_Places_Dollars	0
499	ITMTRKOP1	ASI_Item_Tracking_Option	Integer	DDL_Track	0
500	VCTNMTHD1	ASI_Valuation_Method	Integer	DDL_Valuation_Method	0
501	MODIFDT11	ASI_Modified_Date2	Date	DT	8
502	CREATDDT11	ASI_Created_Date2	Date	DT	8
503	PRCLEVEL1	ASI_PriceLevel	String	STR10_LBAU	10
504	PRMDATE1	ASI_Promised_Date	Date	DATE_L	0
505	PRMSHPDTE1	ASI_Promised_Ship_Date	Date	DATE_L	0
506	LOCNCODE1	ASI_Location_Code	String	STR10_Location_Code	10
507	COMMNTID1	ASI_Comment_ID	String	STR15_Comment_ID	15
508	CURNCYID11	ASI_Currency_ID2	String	STR15_Currency_ID	15
509	ASI_Currency_Index	ASI_Currency_Index	Integer	INT3	3
510	XCHGRATE1	ASI_Exchange_Rate	Currency (Variable)	DLR14_Exchange_Rate	14
511	RATECALC1	ASI_Rate_Calc_Method	Integer	INT	0
512	DENXRATE1	ASI_Denomination_Exchange_Rate	Currency (Variable)	DLR14_Exchange_Rate	14
513	Change_Order_Flag1	ASI_Change_Order_Flag	Boolean	Boolean	0
514	VENDNAME1	ASI_Vendor_Name	String	STR64_Vendor_Name	64
515	VADCDPAD1	ASI_Vendor_Address_Code_Purchase_Address	String	STR15_Address_Code	15
516	ADDRESS111	ASI_Address_12	String	STR60	60
517	ADDRESS211	ASI_Address_22	String	STR60	60
518	ADDRESS311	ASI_Address_32	String	STR60	60
519	CITY11	ASI_City2	String	STR35	35
520	STATE11	ASI_State2	String	STR30_State	29
521	ZIPCODE1	ASI_Zip_Code	String	STR10	10
522	COUNTRY11	ASI_Country2	String	STR60	60
523	PHNUMBR11	ASI_Phone_Number_1	String	Phone_Number	14
524	PHNUMBR21	ASI_Phone_Number_2	String	Phone_Number	14
525	FAXNUMBR1	ASI_Fax_Number	String	STR14_FAX	14
526	SHIPMTHD11	ASI_Shipping_Method2	String	STR15_Shipping_Method	15
527	CURNCYID111	ASI_Currency_ID3	String	STR15_Currency_ID	15
528	TXRGNNUM11	ASI_Tax_Registration_Number2	String	STR25	25
529	MINORDER1	ASI_Minimum_Order	Currency	DLR17_$U2	17
530	PYMTRMID11	ASI_Payment_Terms_ID2	String	STR20_Payment_Terms_ID	20
531	COMMENT111	ASI_Comment12	String	STR30	30
532	COMMENT211	ASI_Comment22	String	STR30	30
533	KPCALHST11	ASI_Keep_Calendar_History2	Boolean	CB_Keep_Calendar_History	0
534	KPERHIST11	ASI_Keep_Period_History2	Boolean	CB_Keep_Period_History	0
535	KPTRXHST11	ASI_Keep_Trx_History2	Boolean	CB_Keep_Trx_History	0
536	HOLD11	ASI_Hold2	Boolean	CB_Hold	0
537	PURPVIDX1	ASI_Purchase_Price_Variance_Index	Long Integer	LI_14	14
538	NOTEINDX111	ASI_Note_Index3	Currency	DLR14	14
539	MODIFDT111	ASI_Modified_Date3	Date	DT	8
540	CREATDDT111	ASI_Created_Date3	Date	DT	8
541	RATETPID11	ASI_Rate_Type_ID2	String	STR15_Rate_Type_ID	15
542	FREEONBOARD1	ASI_Free_On_Board	Integer	DDL_Free_On_Board	0
543	DISGRPER11	ASI_Discount_Grace_Period2	Integer	INT2_U0	2
544	DUEGRPER11	ASI_Due_Date_Grace_Period2	Integer	INT2_U0	2
545	GOVCRPID1	ASI_Governmental_Corporate_ID	String	STR30_Gov_Corp_ID	30
546	GOVINDID1	ASI_Governmental_Individual_ID	String	STR30_Gov_Indiv_ID	30
547	PHONE311	ASI_Phone_32	String	Phone_Number	14
548	ONORDAMT11	ASI_On_Order_Amount2	Currency	DLR19_RBS0_UTR$	19
549	ASI_Required_Date	ASI_Required_Date	Date	DATE_L	0
550	LOCNCODE11	ASI_Location_Code2	String	STR10_Location_Code	10
551	TRXSORCE	TRX Source	String	STR13	13
552	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	Integer	DDL_Purchase_Tax_Options	0
553	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Purchasing Line Items'].Purchase_Item_Tax_Schedu AS 'SmartList Purchasing Line Items-Purchase Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Line Items'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
554	Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Purchasing Line Items'].Purchase_Site_Tax_Schedu AS 'SmartList Purchasing Line Items-Purchase Site Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP21 AS ['SmartList Purchasing Line Items'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Line Items'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
555	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
556	TAXAMNT1	ASI_Tax_Amount	Currency	DLR17_RBS0_UTR$	17
557	ORTAXAMT1	ASI_Originating_Tax_Amount	Currency	DLR17_RBS0_UTR$	17
558	Landed_Cost_Group_ID	Landed Cost Group ID	String	STR15_LBAU	15
559	PLNNDSPPLID	Planned Supply ID	Integer	INT	0
560	ASISHIPMTHD3	ASI_Shipping_Method3	String	STR15_Shipping_Method	15
561	ORIGPRMDATE	Original Promised Date	Date	DT	8
562	FSTRCPTDT	First Receipt Date	Date	DT	8
563	LSTRCPTDT	Last Receipt Date	Date	DT	8
564	CNTRLEXTQTY	Control Line Ext Qty	Currency	DLR17_QTY_RBS0_UTR	17
565	CNTRLEXTCOST	Control Line Ext Cost	Currency	DLR17_RBS0_UTR$	17
566	REMAINEXTQTY	Remaining Ext Qty	Currency	DLR17_QTY_RBS0_UTR	17
567	ASI_Address_Code	ASI_Address_Code	String	STR15_Address_Code	15
568	CMPNYNAM1	ASI_Company_Name	String	STR64_Company_Name	64
569	CONTACT1	ASI_Contact	String	STR60	60
570	ADDRESS1111	ASI_Address_13	String	STR60	60
571	ADDRESS2111	ASI_Address_23	String	STR60	60
572	ADDRESS3111	ASI_Address_33	String	STR60	60
573	CITY3	ASI_City3	String	STR35	35
574	STATE3	ASI_State3	String	STR30_State	29
575	ZIP3	ASI_Zip3	String	STR10	10
576	COUNTRY3	ASI_Country3	String	STR60	60
577	PHONE1111	ASI_Phone_13	String	Phone_Number	14
578	PHONE2111	ASI_Phone_23	String	Phone_Number	14
579	PHONE3111	ASI_Phone_33	String	Phone_Number	14
580	FAX3	ASI_Fax3	String	STR14_FAX	14
581	ADDRSOURCE	Address Source	Integer	INT1	1
582	PURCHSITETXSCHSRC	Purchase Site Tax Schedule Source	Integer	INT1	1
583	UMSCHDSC	U Of M Schedule Description	String	STR30	30
584	QTYSHPPD	QTY Shipped	Currency	DLR17_QTY_RBS0_UTR	17
585	QTYINVCD	QTY Invoiced	Currency	DLR17_QTY_RBS0_UTR	17
586	QTYREJ	QTY Rejected	Currency	DLR17_QTY_RBS0_UTR	17
587	QTYMATCH	QTY Matched	Currency	DLR17_QTY_RBS0_UTR	17
588	ProjNum	Project Number	String	STR15_LBAU	15
589	CostCatID	Cost Category ID	String	STR15_LBAU	15
590	Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	DLR17_RBS0_UTR$	17
591	QTYINVRESERVE	QTY Invoice Reserve	Currency	DLR17_QTY_RBS0_UTR	17
592	QTYRESERVED	QTY Reserved	Currency	DLR17_QTY_RBS0_UTR	17

azurecurve Products SmartList (1493)PathnameSmartList Purchasing Line Items (ASIEXP21)

Leave a Reply Cancel reply