SmartList Invoicing Transaction Work (ASIEXP25)

azurecurve Products SmartList (1493)PathnameSmartList Invoicing Transaction Work (ASIEXP25)

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

Display Name: SmartList Invoicing Transaction Work
Physical Name: ASIEXP25
Technical Name: ASI_IVC_HDR_WORK_Explorer

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
2	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
3	ASI_Document_Status	ASI_Document_Status	Integer	INT	0
4	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
5	INVCNMBR	Invoice Number	String	STR20_IVC_Document_Number	17
6	BACHNUMB	Batch Number	String	STR15_LBAU	15
7	BCHSOURC	Batch Source	String	STR15	15
8	PCKSLPNO	Packing Slip Number	String	STR20_IVC_Document_Number	17
9	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].CUSTNMBR AS 'SmartList Invoicing Transaction Work-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SmartList Invoicing Transaction Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
10	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
11	CSTPONBR	Customer PO Number	String	STR20_Document_Number	20
12	POSTDATE	Post Date	Date	DT_Date	6
13	GLPOSTDT	GL Posting Date	Date	DT	8
14	DOCDATE	Document Date	Date	DT	8
15	QUOTEDAT	Quote Date	Date	DT	8
16	ORDRDATE	Order Date	Date	DT	8
17	DISCDATE	Discount Date	Date	DT	8
18	DUEDATE	Due Date	Date	DT	8
19	HOLDNT	Hold NT	Boolean	CB	0
20	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].SHIPMTHD AS 'SmartList Invoicing Transaction Work-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList Invoicing Transaction Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
21	TAXEXMT1	Tax Exempt 1	String	STR25	25
22	TAXEXMT2	Tax Exempt 2	String	STR25	25
23	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 Invoicing Transaction Work'].TAXSCHID AS 'SmartList Invoicing Transaction Work-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Invoicing Transaction Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
24	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].FRTSCHID AS 'SmartList Invoicing Transaction Work-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Invoicing Transaction Work'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
25	FRGTTXBL	Freight Taxable	Integer	DDL_Tax_Options	0
26	FRTTXAMT	Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
27	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].MSCSCHID AS 'SmartList Invoicing Transaction Work-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Invoicing Transaction Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
28	MISCTXBL	Misc Taxable	Integer	DDL_Tax_Options	0
29	MSCTXAMT	Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
30	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].SLPRSNID AS 'SmartList Invoicing Transaction Work-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SmartList Invoicing Transaction Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
31	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].SALSTERR AS 'SmartList Invoicing Transaction Work-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SmartList Invoicing Transaction Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR
32	TXRGNNUM	Tax Registration Number	String	STR25	25
33	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].PYMTRMID AS 'SmartList Invoicing Transaction Work-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList Invoicing Transaction Work'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
34	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
35	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].LOCNCODE AS 'SmartList Invoicing Transaction Work-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SmartList Invoicing Transaction Work'].LOCNCODE = ['Site Setup'].LOCNCODE
36	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].CURNCYID AS 'SmartList Invoicing Transaction Work-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Invoicing Transaction Work'].CURNCYID = ['Currency Setup'].CURNCYID
37	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].COMMNTID AS 'SmartList Invoicing Transaction Work-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN SY04200 AS ['Comment Master'] ON ['SmartList Invoicing Transaction Work'].COMMNTID = ['Comment Master'].COMMNTID
38	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
39	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
40	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
41	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
42	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
43	TXBTXAMT	Taxable Tax Amount	Currency	DLR19_RBSO_UTR$	19
44	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
45	BKTSLSAM	Backout Sales Amount	Currency	DLR19_RBS0_UTR$	19
46	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
47	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
48	DISCFRGT	Discount Available Freight	Currency	DLR17_RBS0_UTR$	17
49	DISCMISC	Discount Available Misc	Currency	DLR17_RBS0_UTR$	17
50	TRDISPCT	Trade Discount Percent	Integer	INT4_%2	4
51	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
52	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
53	PYMTRCVD	Payment Received	Currency	DLR19_RBS0_UTR$	19
54	CODAMNT	COD Amount	Currency	DLR17_RBS0_UTR$	17
55	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
56	DISCRTND	Discount Returned	Currency	DLR17_RBS0_STR$	17
57	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
58	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
59	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
60	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
61	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
62	MRKDNAMT	Markdown Amount	Currency	DLR17_RBS0_UTR$	17
63	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
64	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
65	CNTCPRSN	Contact Person	String	STR60	60
66	ADDRESS1	Address 1	String	STR60	60
67	ADDRESS2	Address 2	String	STR60	60
68	ADDRESS3	Address 3	String	STR60	60
69	CITY	City	String	STR35	35
70	STATE	State	String	STR30_State	29
71	ZIPCODE	Zip Code	String	STR10	10
72	COUNTRY	Country	String	STR60	60
73	PHNUMBR1	Phone Number 1	String	Phone_Number	14
74	PHNUMBR2	Phone Number 2	String	Phone_Number	14
75	PHONE3	Phone 3	String	Phone_Number3	14
76	FAXNUMBR	Fax Number	String	STR14_FAX	14
77	COMAPPTO	Commission Applied To	Integer	GB	0
78	COMDLRAM	Commission Dollar Amount	Currency	DLR17_RBSO_STR$	17
79	NCOMAMNT	Non-Commissioned Amount	Currency	DLR19_RBS0_STR$	19
80	UPSZONE	UPS Zone	String	STR3	3
81	LSTUSRED	Last User to Edit	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].LSTUSRED AS 'SmartList Invoicing Transaction Work-Last User to Edit' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Invoicing Transaction Work'].LSTUSRED = ['Users Master'].USERID
82	LSTEDTDT	Last Edit Date	Date	DT_Date	6
83	MODIFDT	Modified Date	Date	DT	8
84	CREATDDT	Created Date	Date	DT	8
85	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].USER2ENT AS 'SmartList Invoicing Transaction Work-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Invoicing Transaction Work'].USER2ENT = ['Users Master'].USERID
86	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Invoicing Transaction Work'].NOTEINDX AS 'SmartList Invoicing Transaction Work-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP25 AS ['SmartList Invoicing Transaction Work'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Invoicing Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
87	TIMESPRT	Times Printed	Integer	INT4_U0	4
88	NOCARTNS	Number Of Cartons	Integer	INT4_U0	4
89	USERDEF1	User Defined 1	String	STR20	20
90	USERDEF2	User Defined 2	String	STR20	20
91	VOIDSTTS	Void Status	Integer	INT	0
92	TRXSORCE	TRX Source	String	STR13	13
93	PSTGSTUS	Posting Status	Integer	INT	0
94	IVCHDER1	IVC HDR Errors 1	Long Integer	ML_IVC_HDR_Errors_1	0
95	IVCHDER2	IVC HDR Errors 2	Long Integer	ML_IVC_HDR_Errors_2	0
96	IVCLINEERR	IVC LINE Errors	Long Integer	ML_IVC_LINE_Errors	0
97	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
98	COMMENT_1	Comment[1]	String	STR50	50
99	COMMENT_2	Comment[2]	String	STR50	50
100	COMMENT_3	Comment[3]	String	STR50	50
101	COMMENT_4	Comment[4]	String	STR50	50
102	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.
103	ShipToName	ShipToName	String	STR64_Customer_Name	64
104	Tax_Date	Tax Date	Date	DT	8
105	APLYWITH	Apply Withholding	Boolean	Boolean	0
106	WITHHAMT	Withholding Amount	Currency	DLR19_RBSO_UTR$	19
107	CMMTTEXT	Comment Text	Text	TX500	500

azurecurve Products SmartList (1493)PathnameSmartList Invoicing Transaction Work (ASIEXP25)

Leave a Reply Cancel reply