SmartList Purchasing Receipt Lines (ASIEXP28)

azurecurve Products SmartList (1493)PathnameSmartList Purchasing Receipt Lines (ASIEXP28)

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

Display Name: SmartList Purchasing Receipt Lines
Physical Name: ASIEXP28
Technical Name: ASI_POP_ReceiptLine_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	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
6	PONUMBER	PO Number	String	STR17_POP_Number	17
7	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].ITEMNMBR AS 'SmartList Purchasing Receipt Lines-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN IV00101 AS ['Item Master'] ON ['SmartList Purchasing Receipt Lines'].ITEMNMBR = ['Item Master'].ITEMNMBR
8	ITEMDESC	Item Description	String	STR100	100
9	VNDITNUM	Vendor Item Number	String	Item_Number	30
10	VNDITDSC	Vendor Item Description	String	STR100	100
11	UMQTYINB	U Of M QTY In Base	Currency	DLR17_QTY_RBS0_STR	17
12	ACTLSHIP	Actual Ship Date	Date	DT	8
13	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].COMMNTID AS 'SmartList Purchasing Receipt Lines-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN SY04200 AS ['Comment Master'] ON ['SmartList Purchasing Receipt Lines'].COMMNTID = ['Comment Master'].COMMNTID
14	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].INVINDX AS 'SmartList Purchasing Receipt Lines-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Receipt Lines'].INVINDX = ['Account Index Master'].ACTINDX
15	UOFM	U Of M	String	U_Of_M	8
16	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
17	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
18	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].LOCNCODE AS 'SmartList Purchasing Receipt Lines-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SmartList Purchasing Receipt Lines'].LOCNCODE = ['Site Setup'].LOCNCODE
19	NONINVEN	Non IV	Integer	INT1	1
20	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
21	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
22	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
23	TRXSORCE	TRX Source	String	STR13	13
24	JOBNUMBR	Job Number	String	STR17_LBAU	17
25	COSTCODE	Cost Code	String	STR27	27
26	COSTTYPE	Cost Code Type	Integer	INT3_RB0_U	3
27	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].CURNCYID AS 'SmartList Purchasing Receipt Lines-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Purchasing Receipt Lines'].CURNCYID = ['Currency Setup'].CURNCYID
28	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].CURRNIDX AS 'SmartList Purchasing Receipt Lines-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Purchasing Receipt Lines'].CURRNIDX = ['Currency Setup'].CURRNIDX
29	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
30	RATECALC	Rate Calc Method	Integer	INT	0
31	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
32	ORUNTCST	Originating Unit Cost	Currency	DLR17_RBS0_UTR$	17
33	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
34	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
35	BOLPRONUMBER	BOL_PRO Number	String	STR30	30
36	Capital_Item	Capital Item	Boolean	CB_Capital_Item	0
37	Product_Indicator	Product Indicator	Integer	DDL_Product_Indicator	0
38	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	Integer	DDL_Purchase_Tax_Options	0
39	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 Receipt Lines'].Purchase_Item_Tax_Schedu AS 'SmartList Purchasing Receipt Lines-Purchase Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Receipt Lines'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
40	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 Receipt Lines'].Purchase_Site_Tax_Schedu AS 'SmartList Purchasing Receipt Lines-Purchase Site Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Purchasing Receipt Lines'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
41	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
42	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
43	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
44	BKTPURAM	Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
45	OBKPURAMT	Originating Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
46	Revalue_Inventory	Revalue Inventory	Boolean	CB_Revalue_Inventory	0
47	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].PURPVIDX AS 'SmartList Purchasing Receipt Lines-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Purchasing Receipt Lines'].PURPVIDX = ['Account Index Master'].ACTINDX
48	PSTGSTUS	Posting Status	Integer	INT	0
49	POPTYPE	POP Type	Integer	DDL_POP_Type	0
50	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].VENDORID AS 'SmartList Purchasing Receipt Lines-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SmartList Purchasing Receipt Lines'].VENDORID = ['PM Vendor Master File'].VENDORID
51	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
52	VNDDOCNM	Vendor Document Number	String	STR20_Document_Number	20
53	GLPOSTDT	GL Posting Date	Date	DT	8
54	receiptdate	Receipt Date	Date	DT	8
55	BCHSOURC	Batch Source	String	STR15	15
56	BACHNUMB	Batch Number	String	STR15_LBAU	15
57	POSTEDDT	Posted Date	Date	DATE	6
58	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].PTDUSRID AS 'SmartList Purchasing Receipt Lines-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Purchasing Receipt Lines'].PTDUSRID = ['Users Master'].USERID
59	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Purchasing Receipt Lines'].USER2ENT AS 'SmartList Purchasing Receipt Lines-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP28 AS ['SmartList Purchasing Receipt Lines'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Purchasing Receipt Lines'].USER2ENT = ['Users Master'].USERID
60	CREATDDT	Created Date	Date	DT	8
61	MODIFDT	Modified Date	Date	DT	8
62	Tax_Date	Tax Date	Date	DT	8
63	QTYSHPPD	QTY Shipped	Currency	DLR17_QTY_RBS0_UTR	17
64	QTYINVCD	QTY Invoiced	Currency	DLR17_QTY_RBS0_UTR	17
65	QTYREJ	QTY Rejected	Currency	DLR17_QTY_RBS0_UTR	17
66	Landed_Cost_Group_ID	Landed Cost Group ID	String	STR15_LBAU	15
67	Landed_Cost	Landed Cost	Boolean	CB	0
68	RCPTRETNUM	Receipt Return Number	String	STR17_POP_Number	17
69	INVRETNUM	Invoice Return Number	String	STR17_POP_Number	17
70	BIN	Bin	String	STR15_Bin	15
71	Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	DLR17_RBS0_UTR$	17
72	QTYRESERVED	QTY Reserved	Currency	DLR17_QTY_RBS0_UTR	17
73	QTYINVRESERVE	QTY Invoice Reserve	Currency	DLR17_QTY_RBS0_UTR	17
74	UMSCHDSC	U Of M Schedule Description	String	STR30	30
75	QTYMATCH	QTY Matched	Currency	DLR17_QTY_RBS0_UTR	17
76	ProjNum	Project Number	String	STR15_LBAU	15
77	CostCatID	Cost Category ID	String	STR15_LBAU	15

azurecurve Products SmartList (1493)PathnameSmartList Purchasing Receipt Lines (ASIEXP28)

Leave a Reply Cancel reply