SmartList Purchasing Receipts (ASIEXP27)

azurecurve Products SmartList (1493)PathnameSmartList Purchasing Receipts (ASIEXP27)

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

Display Name: SmartList Purchasing Receipts
Physical Name: ASIEXP27
Technical Name: ASI_POP_Receipt_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	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
5	POPTYPE	POP Type	Integer	DDL_POP_Type	0
6	VNDDOCNM	Vendor Document Number	String	STR20_Document_Number	20
7	receiptdate	Receipt Date	Date	DT	8
8	GLPOSTDT	GL Posting Date	Date	DT	8
9	ACTLSHIP	Actual Ship Date	Date	DT	8
10	BCHSOURC	Batch Source	String	STR15	15
11	BACHNUMB	Batch Number	String	STR15_LBAU	15
12	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SmartList Purchasing Receipts'].VENDORID AS 'SmartList Purchasing Receipts-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SmartList Purchasing Receipts'].VENDORID = ['PM Vendor Master File'].VENDORID
13	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
14	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
15	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
16	TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	Trade Discount Percent (Precise)	23
17	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
18	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
19	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
20	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
21	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList Purchasing Receipts'].PYMTRMID AS 'SmartList Purchasing Receipts-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList Purchasing Receipts'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
22	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
23	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
24	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
25	DISCDATE	Discount Date	Date	DT	8
26	DUEDATE	Due Date	Date	DT	8
27	REFRENCE	Reference	String	STR30	30
28	VOIDSTTS	Void Status	Integer	INT	0
29	POPHDR1	POP HDR Errors 1	Long Integer	ML_POP_HDR_Errors_1	0
30	POPHDR2	POP HDR Errors 2	Long Integer	ML_POP_HDR_Errors_2	0
31	POPLNERR	POP LINE Errors	Long Integer	ML_POP_LINE_Errors	0
32	POSTEDDT	Posted Date	Date	DATE	6
33	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Purchasing Receipts'].PTDUSRID AS 'SmartList Purchasing Receipts-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Purchasing Receipts'].PTDUSRID = ['Users Master'].USERID
34	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Purchasing Receipts'].USER2ENT AS 'SmartList Purchasing Receipts-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Purchasing Receipts'].USER2ENT = ['Users Master'].USERID
35	CREATDDT	Created Date	Date	DT	8
36	MODIFDT	Modified Date	Date	DT	8
37	TRXSORCE	TRX Source	String	STR13	13
38	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
39	Tax_Date	Tax Date	Date	DT	8
40	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Purchasing Receipts'].CURNCYID AS 'SmartList Purchasing Receipts-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Purchasing Receipts'].CURNCYID = ['Currency Setup'].CURNCYID
41	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Purchasing Receipts'].CURRNIDX AS 'SmartList Purchasing Receipts-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Purchasing Receipts'].CURRNIDX = ['Currency Setup'].CURRNIDX
42	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 Receipts'].RATETPID AS 'SmartList Purchasing Receipts-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList Purchasing Receipts'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
43	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 Receipts'].EXGTBLID AS 'SmartList Purchasing Receipts-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['SmartList Purchasing Receipts'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
44	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
45	EXCHDATE	Exchange Date	Date	DT_Date	6
46	TIME1	Time	Time	TM6	6
47	RATECALC	Rate Calc Method	Integer	INT	0
48	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
49	MCTRXSTT	MC Transaction State	Integer	INT1	1
50	ORSUBTOT	Originating Subtotal	Currency	DLR17_RBS0_STR$	17
51	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
52	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
53	ORMISCAMT	Originating Misc Amount	Currency	DLR19_RBSO_UTR$	19
54	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
55	OR1099AM	Originating 1099 Amount	Currency	DLR17_RBS0_UTR$	17
56	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
57	ORDAVAMT	Originating Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
58	WITHHAMT	Withholding Amount	Currency	DLR19_RBSO_UTR$	19
59	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
60	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.
61	TXRGNNUM	Tax Registration Number	String	STR25	25
62	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 Receipts'].TAXSCHID AS 'SmartList Purchasing Receipts-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Receipts'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
63	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
64	Purchase_Freight_Taxable	Purchase Freight Taxable	Integer	DDL_Purchase_Tax_Options	0
65	Purchase_Misc_Taxable	Purchase Misc Taxable	Integer	DDL_Purchase_Tax_Options	0
66	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Purchasing Receipts'].FRTSCHID AS 'SmartList Purchasing Receipts-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Receipts'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
67	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Purchasing Receipts'].MSCSCHID AS 'SmartList Purchasing Receipts-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Receipts'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
68	FRTTXAMT	Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
69	ORFRTTAX	Originating Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
70	MSCTXAMT	Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
71	ORMSCTAX	Originating Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
72	DISCFRGT	Discount Available Freight	Currency	DLR17_RBS0_UTR$	17
73	ORDAVFRT	Originating Discount Available Freight	Currency	DLR17_RBS0_UTR$	17
74	DISCMISC	Discount Available Misc	Currency	DLR17_RBS0_UTR$	17
75	ORDAVMSC	Originating Discount Available Misc	Currency	DLR17_RBS0_UTR$	17
76	BackoutFreightTaxAmt	Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
77	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
78	BackoutMiscTaxAmt	Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
79	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
80	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
81	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
82	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
83	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
84	APLYWITH	Apply Withholding	Boolean	Boolean	0
85	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
86	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList Purchasing Receipts'].SHIPMTHD AS 'SmartList Purchasing Receipts-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList Purchasing Receipts'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
87	PSTGSTUS	Posting Status	Integer	INT	0
88	HIESTBAL	Highest Balance	Currency	DLR17_RBS0_UTR$	17
89	CURRBLNC	Current Balance	Currency	DLR19_RBS0_STR$	19
90	NOINVYTD	Number of Invoices YTD	Long Integer	LI_9U0	9
91	NOINVLIF	Number of Invoices LIFE	Long Integer	LI_9U0	9
92	NOINVLYR	Number of Invoices LYR	Long Integer	LI_9U0	9
93	NOPINYTD	Number of Paid Invoices YTD	Long Integer	LI_9U0	9
94	NOPILIFE	Number of Paid Invoices LIFE	Long Integer	LI_9U0	9
95	AMBLDTYD	Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
96	AMBLDLIF	Amount Billed LIFE	Currency	DLR19_RBS0_STR$	19
97	AMBLDLYR	Amount Billed LYR	Currency	DLR19_RBS0_STR$	19
98	AMTPDYTD	Amount Paid YTD	Currency	DLR19_RBS0_STR$	19
99	AMTPDLIF	Amount Paid LIFE	Currency	DLR19_RBS0_STR$	19
100	AMTPDLYR	Amount Paid LYR	Currency	DLR19_RBS0_STR$	19
101	TEN99AYTD	1099 Amount YTD	Currency	DLR19_RBS0_STR$	19
102	TEN99ALIF	1099 Amount LIFE	Currency	DLR19_RBS0_STR$	19
103	TEN99ALYR	1099 Amount LYR	Currency	DLR19_RBS0_STR$	19
104	DISAVYTD	Discount Available YTD	Currency	DLR19_RBS0_STR$	19
105	DISAVLIF	Discount Available LIFE	Currency	DLR19_RBS0_STR$	19
106	DISAVLYR	Discount Available LYR	Currency	DLR19_RBS0_STR$	19
107	DISTKYTD	Discount Taken YTD	Currency	DLR19_RBS0_STR$	19
108	DISTKNLF	Discount Taken LIFE	Currency	DLR19_RBS0_STR$	19
109	DISTKLYR	Discount Taken LYR	Currency	DLR19_RBS0_STR$	19
110	DISLSYTD	Discount Lost YTD	Currency	DLR19_RBS0_STR$	19
111	DISLSTLF	Discount Lost LIFE	Currency	DLR19_RBS0_STR$	19
112	DISLSLYR	Discount Lost LYR	Currency	DLR19_RBS0_STR$	19
113	FINCHYTD	Finance Charge YTD	Currency	DLR19_RBS0_STR$	19
114	FINCHLIF	Finance Charge LIFE	Currency	DLR19_RBS0_STR$	19
115	FINCHLYR	Finance Charge LYR	Currency	DLR19_RBS0_STR$	19
116	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
117	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
118	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
119	RTRNSYTD	Returns YTD	Currency	DLR19_RBS0_STR$	19
120	RTRNSLIF	Returns LIFE	Currency	DLR19_RBS0_STR$	19
121	RTRNSLYR	Returns LYR	Currency	DLR19_RBS0_STR$	19
122	TRDTYTD	Trade Discounts Taken YTD	Currency	DLR19_RBSO_STR$	19
123	TRDTKLIF	Trade Discounts Taken LIFE	Currency	DLR19_RBSO_STR$	19
124	TRDTLYR	Trade Discounts Taken LYR	Currency	DLR19_RBSO_STR$	19
125	NFNCHYTD	Number of Finance Charges YTD	Long Integer	LI_9U0	9
126	NFNCHLIF	Number of Finance Charges LIFE	Long Integer	LI_9U0	9
127	NFNCHLYR	Number of Finance Charges LYR	Long Integer	LI_9U0	9
128	RTNGOWED	Retainage Owed	Currency	DLR17_RBS0_STR$	17
129	LSTCHNUM	Last Check Number	String	Check_Number	20
130	LSTCHKDT	Last Check Date	Date	DT	8
131	LSTCHAMT	Last Check Amount	Currency	DLR17_RBS0_UTR$	17
132	LSTINNUM	Last Invoice Number	String	STR20	20
133	LSTINVAM	Last Invoice Amount	Currency	DLR17_RBS0_UTR$	17
134	LSTPURDT	Last Purchase Date	Date	DT	8
135	FSTPURDT	First Purchase Date	Date	DT	8
136	CURUNPBN	Current Unapplied Payment Balance	Currency	DLR17_RBS0_UTR$	17
137	UNPDFNCH	Unpaid Finance Charges	Currency	DLR17_RBS0_UTR$	17
138	DYCHTCLR	Days Checks To Clear	Integer	INT3_U0	3
139	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
140	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
141	ACCRDINV	Accured Inventory	Currency	DLR17_RBS0_STR$	17
142	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
143	WITHYTD	Withholding YTD	Currency	DLR19_RBS0_STR$	19
144	Withholding_LIFE	Withholding LIFE	Currency	DLR19_RBS0_STR$	19
145	WITHLYR	Withholding LYR	Currency	DLR19_RBS0_STR$	19
146	User_Defined_List01	User Defined List01	String	STR30	30
147	User_Defined_List02	User Defined List02	String	STR30	30
148	User_Defined_List03	User Defined List03	String	STR30	30
149	User_Defined_List04	User Defined List04	String	STR30	30
150	User_Defined_List05	User Defined List05	String	STR30	30
151	User_Defined_Text01	User Defined Text01	String	STR30	30
152	User_Defined_Text02	User Defined Text02	String	STR30	30
153	User_Defined_Text03	User Defined Text03	String	STR30	30
154	User_Defined_Text04	User Defined Text04	String	STR30	30
155	User_Defined_Text05	User Defined Text05	String	STR30	30
156	User_Defined_Text06	User Defined Text06	String	STR30	30
157	User_Defined_Text07	User Defined Text07	String	STR30	30
158	User_Defined_Text08	User Defined Text08	String	STR30	30
159	User_Defined_Text09	User Defined Text09	String	STR30	30
160	User_Defined_Text10	User Defined Text10	String	STR30	30
161	User_Defined_Date01	User Defined Date01	Date	DT	8
162	User_Defined_Date02	User Defined Date02	Date	DT	8
163	User_Defined_Date03	User Defined Date03	Date	DT	8
164	User_Defined_Date04	User Defined Date04	Date	DT	8
165	User_Defined_Date05	User Defined Date05	Date	DT	8
166	User_Defined_Date06	User Defined Date06	Date	DT	8
167	User_Defined_Date07	User Defined Date07	Date	DT	8
168	User_Defined_Date08	User Defined Date08	Date	DT	8
169	User_Defined_Date09	User Defined Date09	Date	DT	8
170	User_Defined_Date10	User Defined Date10	Date	DT	8
171	User_Defined_Date11	User Defined Date11	Date	DT	8
172	User_Defined_Date12	User Defined Date12	Date	DT	8
173	User_Defined_Date13	User Defined Date13	Date	DT	8
174	User_Defined_Date14	User Defined Date14	Date	DT	8
175	User_Defined_Date15	User Defined Date15	Date	DT	8
176	User_Defined_Date16	User Defined Date16	Date	DT	8
177	User_Defined_Date17	User Defined Date17	Date	DT	8
178	User_Defined_Date18	User Defined Date18	Date	DT	8
179	User_Defined_Date19	User Defined Date19	Date	DT	8
180	User_Defined_Date20	User Defined Date20	Date	DT	8
181	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 Receipts'].VADCDTRO AS 'SmartList Purchasing Receipts-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP27 AS ['SmartList Purchasing Receipts'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Purchasing Receipts'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['SmartList Purchasing Receipts'].VENDORID = ['PM Address MSTR'].VENDORID

azurecurve Products SmartList (1493)PathnameSmartList Purchasing Receipts (ASIEXP27)

Leave a Reply Cancel reply