SmartList Sales Transaction (ASIEXP06)

azurecurve Products SmartList (1493)PathnameSmartList Sales Transaction (ASIEXP06)

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

Display Name: SmartList Sales Transaction
Physical Name: ASIEXP06
Technical Name: ASI_SOP_HDR_MSTR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
2	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
3	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
4	ASI_Document_Status	ASI_Document_Status	Integer	INT	0
5	ORIGTYPE	Original Type	Integer	DDL_SOP_Type	0
6	ORIGNUMB	Original Number	String	STR20_SOP_Number	17
7	DOCID	Document ID	String	STR15_LBAU	15
8	DOCDATE	Document Date	Date	DT	8
9	GLPOSTDT	GL Posting Date	Date	DT	8
10	QUOTEDAT	Quote Date	Date	DT	8
11	QUOEXPDA	Quote Expiration Date	Date	DT	8
12	ORDRDATE	Order Date	Date	DT	8
13	INVODATE	Invoice Date	Date	DT	8
14	BACKDATE	Back Order Date	Date	DT	8
15	RETUDATE	Return Date	Date	DT	8
16	ReqShipDate	Requested Ship Date	Date	DT	8
17	FUFILDAT	Fulfillment Date	Date	DT	8
18	ACTLSHIP	Actual Ship Date	Date	DT	8
19	DISCDATE	Discount Date	Date	DT	8
20	DUEDATE	Due Date	Date	DT	8
21	REPTING	Repeating	Boolean	CB_Repeating	0
22	TRXFREQU	TRX Frequency	Integer	DDL_TRX_Frequency	0
23	TIMEREPD	Times Repeated	Integer	INT4_U0	4
24	TIMETREP	Times To Repeat	Integer	INT4_U0	4
25	DYSTINCR	Days to Increment	Integer	INT3_RB0_U	3
26	DTLSTREP	Date Last Repeated	Date	DT	8
27	DSTBTCH1	Dest Batch 1	String	STR15_LBAU	15
28	DSTBTCH2	Dest Batch 2	String	STR15_LBAU	15
29	USDOCID1	Use Document ID 1	String	STR15_LBAU	15
30	USDOCID2	Use Document ID 2	String	STR15_LBAU	15
31	DISCFRGT	Discount Available Freight	Currency	DLR17_RBS0_UTR$	17
32	ORDAVFRT	Originating Discount Available Freight	Currency	DLR17_RBS0_UTR$	17
33	DISCMISC	Discount Available Misc	Currency	DLR17_RBS0_UTR$	17
34	ORDAVMSC	Originating Discount Available Misc	Currency	DLR17_RBS0_UTR$	17
35	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
36	ORDAVAMT	Originating Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
37	DISCRTND	Discount Returned	Currency	DLR17_RBS0_STR$	17
38	ORDISRTD	Originating Discount Returned	Currency	DLR17_RBS0_STR$	17
39	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
40	ORDISTKN	Originating Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
41	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
42	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
43	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
44	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
45	ORDATKN	Originating Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
46	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList Sales Transaction'].PYMTRMID AS 'SmartList Sales Transaction-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList Sales Transaction'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
47	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
48	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SmartList Sales Transaction'].LOCNCODE AS 'SmartList Sales Transaction-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SmartList Sales Transaction'].LOCNCODE = ['Site Setup'].LOCNCODE
49	BCHSOURC	Batch Source	String	STR15	15
50	BACHNUMB	Batch Number	String	STR15_LBAU	15
51	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SmartList Sales Transaction'].CUSTNMBR AS 'SmartList Sales Transaction-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SmartList Sales Transaction'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
52	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
53	CSTPONBR	Customer PO Number	String	STR20_Document_Number	20
54	PROSPECT	Prospect	Integer	INT1	1
55	MSTRNUMB	Master Number	Long Integer	LI_MasterNumber	9
56	PCKSLPNO	Packing Slip Number	String	STR20_IVC_Document_Number	17
57	PICTICNU	Picking Ticket Number	String	STR20_SOP_Number	17
58	MRKDNAMT	Markdown Amount	Currency	DLR17_RBS0_UTR$	17
59	ORMRKDAM	Originating Markdown Amount	Currency	DLR17_RBS0_UTR$	17
60	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
61	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
62	CNTCPRSN	Contact Person	String	STR60	60
63	ADDRESS1	Address 1	String	STR60	60
64	ADDRESS2	Address 2	String	STR60	60
65	ADDRESS3	Address 3	String	STR60	60
66	CITY	City	String	STR35	35
67	STATE	State	String	STR30_State	29
68	ZIPCODE	Zip Code	String	STR10	10
69	COUNTRY	Country	String	STR60	60
70	PHNUMBR1	Phone Number 1	String	Phone_Number	14
71	PHNUMBR2	Phone Number 2	String	Phone_Number	14
72	FAXNUMBR	Fax Number	String	STR14_FAX	14
73	COMAPPTO	Commission Applied To	Integer	GB	0
74	COMMAMNT	Commission Amount	Currency	DLR17_RBS0_STR$	17
75	OCOMMAMT	Originating Commission Amount	Currency	DLR17_RBSO_STR$	17
76	CMMSLAMT	Commission Sale Amount	Currency	DLR17_RBS0_STR$	17
77	ORCOSAMT	Originating Commission Sales Amount	Currency	DLR17_RBS0_STR$	17
78	NCOMAMNT	Non-Commissioned Amount	Currency	DLR19_RBS0_STR$	19
79	ORNCMAMT	Originating Non-Commissioned Amount	Currency	DLR19_RBS0_STR$	19
80	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList Sales Transaction'].SHIPMTHD AS 'SmartList Sales Transaction-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList Sales Transaction'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
81	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
82	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
83	TRDISPCT	Trade Discount Percent	Integer	INT4_%2	4
84	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
85	ORSUBTOT	Originating Subtotal	Currency	DLR17_RBS0_STR$	17
86	REMSUBTO	Remaining Subtotal	Currency	DLR17_RBS0_UTR$	17
87	OREMSUBT	Originating Remaining Subtotal	Currency	DLR17_RBS0_UTR$	17
88	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
89	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
90	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
91	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
92	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
93	ORMISCAMT	Originating Misc Amount	Currency	DLR19_RBSO_UTR$	19
94	TXENGCLD	Tax Engine Called	Boolean	YN	0
95	TAXEXMT1	Tax Exempt 1	String	STR25	25
96	TAXEXMT2	Tax Exempt 2	String	STR25	25
97	TXRGNNUM	Tax Registration Number	String	STR25	25
98	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 Sales Transaction'].TAXSCHID AS 'SmartList Sales Transaction-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Sales Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
99	TXSCHSRC	Tax Schedule Source	Integer	INT1	1
100	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
101	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Sales Transaction'].FRTSCHID AS 'SmartList Sales Transaction-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Sales Transaction'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
102	FRTTXAMT	Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
103	ORFRTTAX	Originating Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
104	FRGTTXBL	Freight Taxable	Integer	DDL_Tax_Options	0
105	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Sales Transaction'].MSCSCHID AS 'SmartList Sales Transaction-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Sales Transaction'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
106	MSCTXAMT	Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
107	ORMSCTAX	Originating Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
108	MISCTXBL	Misc Taxable	Integer	DDL_Tax_Options	0
109	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
110	ORBKTFRT	Originating Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
111	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
112	ORBKTMSC	Originating Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
113	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
114	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
115	TXBTXAMT	Taxable Tax Amount	Currency	DLR19_RBSO_UTR$	19
116	OTAXTAMT	Originating Taxable Tax Amount	Currency	DLR17_RBS0_UTR$	17
117	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
118	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
119	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.
120	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
121	ORDOCAMT	Originating Document Amount	Currency	DLR17_RBS0_STR$	17
122	PYMTRCVD	Payment Received	Currency	DLR19_RBS0_UTR$	19
123	ORPMTRVD	Originating Payment Received	Currency	DLR19_RBS0_UTR$	19
124	DEPRECVD	Deposit Received	Currency	DLR19_RBS0_UTR$	19
125	ORDEPRVD	Originating Deposit Received	Currency	DLR19_RBS0_UTR$	19
126	CODAMNT	COD Amount	Currency	DLR17_RBS0_UTR$	17
127	ORCODAMT	Originating COD Amount	Currency	DLR17_RBS0_UTR$	17
128	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
129	ORACTAMT	Originating Account Amount	Currency	DLR19_RBS0_UTR$	19
130	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SmartList Sales Transaction'].SALSTERR AS 'SmartList Sales Transaction-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SmartList Sales Transaction'].SALSTERR = ['Sales Territory Master File'].SALSTERR
131	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SmartList Sales Transaction'].SLPRSNID AS 'SmartList Sales Transaction-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SmartList Sales Transaction'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
132	UPSZONE	UPS Zone	String	STR3	3
133	TIMESPRT	Times Printed	Integer	INT4_U0	4
134	PSTGSTUS	Posting Status	Integer	INT	0
135	VOIDSTTS	Void Status	Integer	INT	0
136	ALLOCABY	Allocate By	Integer	DDL_Allocate_By	0
137	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Sales Transaction'].NOTEINDX AS 'SmartList Sales Transaction-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Sales Transaction'].NOTEINDX = ['Record Notes Master'].NOTEINDX
138	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Sales Transaction'].CURNCYID AS 'SmartList Sales Transaction-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Sales Transaction'].CURNCYID = ['Currency Setup'].CURNCYID
139	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Sales Transaction'].CURRNIDX AS 'SmartList Sales Transaction-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Sales Transaction'].CURRNIDX = ['Currency Setup'].CURRNIDX
140	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SmartList Sales Transaction'].RATETPID AS 'SmartList Sales Transaction-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList Sales Transaction'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
141	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['SmartList Sales Transaction'].EXGTBLID AS 'SmartList Sales Transaction-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['SmartList Sales Transaction'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
142	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
143	EXCHDATE	Exchange Date	Date	DT_Date	6
144	TIME1	Time	Time	TM6	6
145	RTCLCMTD	Rate Calculation Method	Integer	GB	0
146	TRXSORCE	TRX Source	String	STR13	13
147	SOPHDRE1	SOP HDR Errors 1	Long Integer	ML_SOP_HDR_Errors_1	0
148	SOPHDRE2	SOP HDR Errors 2	Long Integer	ML_SOP_HDR_Errors_2	0
149	SOPLNERR	SOP LINE Errors	Long Integer	ML_SOP_LINE_Errors	0
150	SOPHDRFL	SOP HDR Flags	Long Integer	ML_SOP_HDR_Flags	0
151	SOPMCERR	SOP MC Posting Error Messages	Long Integer	SOP MC Posting Error Messages	0
152	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['SmartList Sales Transaction'].COMMNTID AS 'SmartList Sales Transaction-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN SY04200 AS ['Comment Master'] ON ['SmartList Sales Transaction'].COMMNTID = ['Comment Master'].COMMNTID
153	REFRENCE	Reference	String	STR30	30
154	POSTEDDT	Posted Date	Date	DATE	6
155	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Sales Transaction'].PTDUSRID AS 'SmartList Sales Transaction-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Sales Transaction'].PTDUSRID = ['Users Master'].USERID
156	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Sales Transaction'].USER2ENT AS 'SmartList Sales Transaction-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Sales Transaction'].USER2ENT = ['Users Master'].USERID
157	CREATDDT	Created Date	Date	DT	8
158	MODIFDT	Modified Date	Date	DT	8
159	ShipToName	ShipToName	String	STR64_Customer_Name	64
160	MCTRXSTT	MC Transaction State	Integer	INT1	1
161	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
162	Tax_Date	Tax Date	Date	DT	8
163	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
164	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
165	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
166	STMTNAME	Statement Name	String	STR64	64
167	SHRTNAME	Short Name	String	STR15	15
168	STADDRCD	Statement Address Code	String	STR15_LBAU	15
169	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList Sales Transaction'].CHEKBKID AS 'SmartList Sales Transaction-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP06 AS ['SmartList Sales Transaction'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList Sales Transaction'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
170	CRLMTTYP	Credit Limit Type	Integer	GB_Amt_Type	0
171	CRLMTAMT	Credit Limit Amount	Currency	DLR17_RBS0_UTR$	17
172	CRLMTPER	Credit Limit Period	Integer	DDL	0
173	CRLMTPAM	Credit Limit Period Amount	Currency	DLR17_RBS0_UTR$	17
174	CUSTDISC	Customer Discount	Integer	INT5_%2	5
175	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
176	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
177	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
178	FNCHATYP	Finance Charge Amt Type	Integer	GB_Amt_Type	0
179	FNCHPCNT	Finance Charge Percent	Integer	INT5_%2	5
180	FINCHDLR	Finance Charge Dollar	Currency	DLR17_RBS0_UTR$	17
181	MXWOFTYP	Maximum Writeoff Type	Integer	GP_Max_Writeoff	0
182	MXWROFAM	Max Writeoff Amount	Currency	DLR17_RBS0_UTR$	17
183	USERDEF1	User Defined 1	String	STR20	20
184	USERDEF2	User Defined 2	String	STR20	20
185	BALNCTYP	Balance Type	Integer	GB_Bal_Type	0
186	STMTCYCL	Statement Cycle	Integer	DDL_Stmt_Cycle	0
187	BANKNAME	Bank Name	String	STR30	30
188	BNKBRNCH	Bank Branch	String	STR20	20
189	DEFCACTY	Default Cash Account Type	Integer	GB	0
190	RMCSHACC	RM Cash Account Index	Long Integer	LI_14	14
191	RMARACC	RM AR Account Index	Long Integer	LI_14	14
192	RMSLSACC	RM Sales Account Index	Long Integer	LI_14	14
193	RMIVACC	RM IV Account Index	Long Integer	LI_14	14
194	RMCOSACC	RM Cost Of Sales Account Index	Long Integer	LI_14	14
195	RMTAKACC	RM Discounts Taken Account Index	Long Integer	LI_14	14
196	RMAVACC	RM Discounts Avail Account Index	Long Integer	LI_14	14
197	RMFCGACC	RM Finance Charge Account Index	Long Integer	LI_14	14
198	RMWRACC	RM Writeoff Account Index	Long Integer	LI_14	14
199	FRSTINDT	First Invoice Date	Date	DT_Date	6
200	INACTIVE	Inactive	Boolean	CB_Inactive	0
201	HOLD	Hold	Boolean	CB_Hold	0
202	CRCARDID	Credit Card ID	String	STR15	15
203	CRCRDNUM	Credit Card Number	String	STR20	20
204	CCRDXPDT	Credit Card Exp Date	Date	DT_Date	6
205	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
206	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
207	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
208	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
209	Revalue_Customer	Revalue Customer	Boolean	CB Revalue Customer	0
210	Post_Results_To	Post Results To	Integer	GB	0
211	FINCHID	Finance Charge ID	String	STR15_Charge_ID	15
212	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
213	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
214	UNPSTDCA	Unposted Cash Amount	Currency	DLR19_RBS0_UTR$	19
215	TNSFCLIF	Total Amount Of NSF Checks Life	Currency	DLR19_RBS0_STR$	19
216	NONSFLIF	Number Of NSF Checks Life	Long Integer	LI6_U0	6
217	CUSTBLNC	Customer Balance	Currency	DLR19_RBS0_STR$	19
218	AGPERAMT_1	Aging Period Amounts[1]	Currency	DLR17_RBSO_STR$	17
219	AGPERAMT_2	Aging Period Amounts[2]	Currency	DLR17_RBSO_STR$	17
220	AGPERAMT_3	Aging Period Amounts[3]	Currency	DLR17_RBSO_STR$	17
221	AGPERAMT_4	Aging Period Amounts[4]	Currency	DLR17_RBSO_STR$	17
222	AGPERAMT_5	Aging Period Amounts[5]	Currency	DLR17_RBSO_STR$	17
223	AGPERAMT_6	Aging Period Amounts[6]	Currency	DLR17_RBSO_STR$	17
224	AGPERAMT_7	Aging Period Amounts[7]	Currency	DLR17_RBSO_STR$	17
225	LASTAGED	Last Aged	Date	DATE	6
226	LSTNSFCD	Last NSF Check Date	Date	DT_Date	6
227	LPYMTAMT	Last Payment Amount	Currency	DLR17_RBS0_STR$	17
228	LASTPYDT	Last Payment Date	Date	DT_Date	6
229	LSTTRXDT	Last Transaction Date	Date	DT_Date	6
230	LSTTRXAM	Last Transaction Amount	Currency	DLR17_RBS0_STR$	17
231	LSTFCHAM	Last Finance Charge Amount	Currency	DLR19_RBS0_STR$	19
232	UPFCHYTD	Unpaid Finance Charges YTD	Currency	DLR17_RBS0_UTR$	17
233	AVDTPLYR	Average Days to Pay - LYR	Integer	INT3_U0	3
234	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
235	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
236	NUMADTPL	Number ADTP Documents - Life	Long Integer	Long_10U	10
237	NUMADTPY	Number ADTP Documents - Year	Long Integer	Long_10U	10
238	NUMADTPR	Number ADTP Documents - LYR	Long Integer	Long_10U	10
239	TDTKNLYR	Total Discounts Taken LYR	Currency	DLR19_RBS0_STR$	19
240	TDTKNYTD	Total Discounts Taken YTD	Currency	DLR19_RBS0_STR$	19
241	TDISAYTD	Total Discounts Available YTD	Currency	DLR19_RBS0_STR$	19
242	TDTKNLTD	Total Discounts Taken LTD	Currency	DLR19_RBS0_STR$	19
243	RETAINAG	Retainage	Currency	DLR19_RBS0_STR$	19
244	TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	DLR19_RBS0_STR$	19
245	NONSFYTD	Number Of NSF Checks YTD	Long Integer	LI6_U0	6
246	UNPSTDSA	Unposted Sales Amount	Currency	DLR19_RBS0_UTR$	19
247	UNPSTOSA	Unposted Other Sales Amount	Currency	DLR19_RBS0_UTR$	19
248	UNPSTOCA	Unposted Other Cash Amount	Currency	DLR19_RBS0_UTR$	19
249	NCSCHPMT	Non Current Scheduled Payments	Currency	DLR19_RBS0_STR$	19
250	TTLSLYTD	Total Sales YTD	Currency	DLR19_RBS0_STR$	19
251	TTLSLLTD	Total Sales LTD	Currency	DLR19_RBS0_STR$	19
252	TTLSLLYR	Total Sales LYR	Currency	DLR19_RBS0_STR$	19
253	TCOSTYTD	Total Costs YTD	Currency	DLR19_RBS0_STR$	19
254	TCOSTLTD	Total Costs LTD	Currency	DLR19_RBS0_STR$	19
255	TCOSTLYR	Total Costs LYR	Currency	DLR19_RBS0_STR$	19
256	TCSHRLTD	Total Cash Received LTD	Currency	DLR19_RBS0_STR$	19
257	TCSHRLYR	Total Cash Received LYR	Currency	DLR19_RBS0_STR$	19
258	TCSHRYTD	Total Cash Received YTD	Currency	DLR19_RBS0_STR$	19
259	TFNCHLTD	Total Finance Charges LTD	Currency	DLR19_RBS0_STR$	19
260	TFNCHLYR	Total Finance Charges LYR	Currency	DLR19_RBS0_STR$	19
261	TFNCHYTD	Total Finance Charges YTD	Currency	DLR19_RBS0_STR$	19
262	FNCHCYTD	Finance Charges CYTD	Currency	DLR19_RBS0_STR$	19
263	FNCHLYRC	Finance Charges LYR Calendar	Currency	DLR19_RBS0_STR$	19
264	TBDDTLYR	Total Bad Deb LYR	Currency	DLR19_RBS0_STR$	19
265	TBDDTLTD	Total Bad Debt LTD	Currency	DLR19_RBS0_STR$	19
266	TBDDTYTD	Total Bad Debt YTD	Currency	DLR19_RBS0_STR$	19
267	TWVFCLTD	Total Waived FC LTD	Currency	DLR19_RBS0_STR$	19
268	TWVFCLYR	Total Waived FC LYR	Currency	DLR19_RBS0_STR$	19
269	TWVFCYTD	Total Waived FC YTD	Currency	DLR19_RBS0_STR$	19
270	TWROFLTD	Total Writeoffs LTD	Currency	DLR19_RBS0_STR$	19
271	TWROFLYR	Total Writeoffs LYR	Currency	DLR19_RBS0_STR$	19
272	TWROFYTD	Total Writeoffs YTD	Currency	DLR19_RBS0_STR$	19
273	TTLINLTD	Total # Invoices LTD	Long Integer	LI6_U0	6
274	TTLINLYR	Total # Invoices LYR	Long Integer	LI6_U0	6
275	TTLINYTD	Total # Invoices YTD	Long Integer	LI6_U0	6
276	TTLFCLTD	Total # FC LTD	Long Integer	LI6_U0	6
277	TTLFCLYR	Total # FC LYR	Long Integer	LI6_U0	6
278	TTLFCYTD	Total # FC YTD	Long Integer	LI6_U0	6
279	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
280	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
281	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
282	HIBALLTD	High Balance LTD	Currency	DLR19_RBSO_STR$	19
283	HIBALLYR	High Balance LYR	Currency	DLR19_RBSO_STR$	19
284	HIBALYTD	High Balance YTD	Currency	DLR19_RBSO_STR$	19
285	LASTSTDT	Last Statement Date	Date	DATE	6
286	LSTSTAMT	Last Statement Amount	Currency	DLR17_RBS0_STR$	17
287	DEPRECV	Deposits Received	Currency	DLR19_RBS0_STR$	19
288	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
289	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
290	DOCFMTID	Document Format ID	String	STR15_LBU	15
291	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
292	PHONE3	Phone 3	String	Phone_Number3	14
293	APLYWITH	Apply Withholding	Boolean	Boolean	0
294	CORRCTN	Correction	Boolean	CB_Correction	0
295	DOCNCORR	Document Number Corrected	String	Document_Number	20
296	SALEDATE	Sale Date	Date	DT	8
297	SEQNCORR	Sequence Number Corrected	Integer	INT	0
298	SHPPGDOC	Shipping Document	Boolean	CB_Shipping_Document	0
299	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
300	WITHHAMT	Withholding Amount	Currency	DLR19_RBSO_UTR$	19
301	CORRNXST	Correction to Nonexisting Transaction	Boolean	Boolean	0
302	SOPHDRE3	SOP HDR Errors 3	Long Integer	ML_SOP_HDR_Errors_3	0
303	TTLRTLTD	Total Returns LTD	Currency	DLR19_RBS0_STR$	19
304	TTLRTLYR	Total Returns LYR	Currency	DLR19_RBS0_STR$	19
305	TTLRTYTD	Total Returns YTD	Currency	DLR19_RBS0_STR$	19
306	CUSTNAME1	ASI_Customer_Name	String	STR64_Customer_Name	64
307	CNTCPRSN1	ASI_Contact_Person	String	STR60	60
308	ASI_Address_Code	ASI_Address_Code	String	STR15_Address_Code	15
309	UPSZONE1	ASI_UPS_Zone	String	STR3	3
310	SHIPMTHD1	ASI_Shipping_Method	String	STR15_Shipping_Method	15
311	TAXSCHID1	ASI_Tax_Schedule_ID	String	STR15_Tax_Schedule_ID	15
312	ADDRESS11	ASI_Address_1	String	STR60	60
313	ADDRESS21	ASI_Address_2	String	STR60	60
314	ADDRESS31	ASI_Address_3	String	STR60	60
315	COUNTRY1	ASI_Country	String	STR60	60
316	CITY1	ASI_City	String	STR35	35
317	STATE1	ASI_State	String	STR30_State	29
318	ZIP1	ASI_Zip	String	STR10	10
319	PHONE11	ASI_Phone_1	String	Phone_Number	14
320	PHONE21	ASI_Phone_2	String	Phone_Number	14
321	FAX1	ASI_Fax	String	STR14_FAX	14
322	PRBTADCD1	ASI_Primary_Billto_Address_Code	String	STR15_LBAU	15
323	PRSTADCD1	ASI_Primary_Shipto_Address_Code	String	STR15_LBAU	15
324	SLPRSNID1	ASI_Salesperson_ID	String	STR15_Salesperson_ID	15
325	PYMTRMID1	ASI_Payment_Terms_ID	String	STR20_Payment_Terms_ID	20
326	CURNCYID1	ASI_Currency_ID	String	STR15_Currency_ID	15
327	RATETPID1	ASI_Rate_Type_ID	String	STR15_Rate_Type_ID	15
328	PRCLEVEL1	ASI_PriceLevel	String	STR10_LBAU	10
329	COMMENT11	ASI_Comment1	String	STR30	30
330	COMMENT21	ASI_Comment2	String	STR30	30
331	TAXEXMT11	ASI_Tax_Exempt_1	String	STR25	25
332	TAXEXMT21	ASI_Tax_Exempt_2	String	STR25	25
333	TXRGNNUM1	ASI_Tax_Registration_Number	String	STR25	25
334	SALSTERR1	ASI_Sales_Territory	String	STR15_Sales_Territory	15
335	NOTEINDX1	ASI_Note_Index	Currency	DLR14	14
336	CREATDDT1	ASI_Created_Date	Date	DT	8
337	MODIFDT1	ASI_Modified_Date	Date	DT	8
338	PHONE31	ASI_Phone_3	String	Phone_Number	14
339	USERDEF11	ASI_User_Defined_1	String	STR20	20
340	USERDEF21	ASI_User_Defined_2	String	STR20	20
341	EXCEPTIONALDEMAND	Exceptional Demand	Boolean	CB_Exceptional_Demand	0
342	SOPSTATUS	SOP Status	Integer	INT	0
343	CUSTPRIORITY	Customer Priority	Integer	DDL_CustomerPriority	0
344	ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	DDL_OrderFulfillDefault	0
345	SHIPCOMPLETE	Ship Complete Document	Boolean	CB_ShipComplete	0
346	SHIPCOMPLETE1	ASI_Ship_Complete_Document	Boolean	CB_ShipComplete	0

azurecurve Products SmartList (1493)PathnameSmartList Sales Transaction (ASIEXP06)

Leave a Reply Cancel reply