Picklist File (EXPV1003)

azurecurve Products Manufacturing (346)3rd PartyPicklist File (EXPV1003)

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

Display Name: Picklist File
Physical Name: EXPV1003
Technical Name: EXP_Picklist

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
2	SEQ_I	Seq	Long Integer	LINT_10	10
3	MANUFACTUREORDERST_I	Manufacture Order Status	Integer	DDL_WO_Status	0
4	PPN_I	PPN	String	STR30_UC	30
5	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Picklist File'].ITEMNMBR AS 'Picklist File-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM EXPV1003 AS ['Picklist File'] INNER JOIN IV00101 AS ['Item Master'] ON ['Picklist File'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	POSITION_NUMBER	Position Number	Integer	INT4_RB_U0	4
7	ROUTINGNAME_I	RoutingName	String	STR30_Item_Number	30
8	RTSEQNUM_I	rtseqnum	String	STR10	10
9	MRPAMOUNT_I	MRP_Amount	Currency	DLR_14_MRP	14
10	MRPISSUEDATE_I	MRP_Issue Date	Date	DATE	6
11	ALLOCATEDATEI	Allocate_Date	Date	DATE	6
12	WCID_I	WC ID	String	STR10_Location_Code	10
13	BACKFLUSHITEM_I	Backflush Item	Boolean	CB_Backflush Item	0
14	ALTERNATE_I	Alternate	Boolean	CB	0
15	ALTERNATEPARTFOR_I	Alternate Part For	String	STR30_Item_Number	30
16	SUBASSEMBLY_I	Subassembly	Boolean	CB	0
17	SUBASSEMBLYOF_I	Subassembly Of	String	STR30	30
18	BOMENGAPPROVAL_I	BOM_Eng_Approval	Boolean	CB	0
19	BOMSINGLELOT_I	BOM_Single_Lot	Boolean	CB	0
20	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Picklist File'].LOCNCODE AS 'Picklist File-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM EXPV1003 AS ['Picklist File'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Picklist File'].LOCNCODE = ['Site Setup'].LOCNCODE
21	ALLOCATED_I	Allocated	Boolean	CB	0
22	ISSUED_I	Issued	Boolean	CB	0
23	FLOORSTOCK_I	Floor Stock	Boolean	CB	0
24	PHANTOM_I	Phantom	Boolean	CB	0
25	CHANGEDATE_I	Change Date	Date	DT	8
26	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Picklist File'].USERID AS 'Picklist File-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM EXPV1003 AS ['Picklist File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Picklist File'].USERID = ['Users Master'].USERID
27	ALLOCATEUID_I	Allocate UID	String	STR15_User_ID	15
28	ISSUEDUID_I	Issued UID	String	STR15_User_ID	15
29	NUMBERSCRAPPED_I	Number Scrapped	Currency	DLR_14_MRP	14
30	BOMCAT_I	BOM Cat	Integer	DDL_BOM_Cat	0
31	BOMNAME_I	BOM Name	String	STR15_LBU	15
32	ACTUAL_CONSUMED_CHECK_I	Actual Consumed Check	Boolean	CB	0
33	REQDATE	Required Date	Date	DATE_L	0
34	UOFM	U Of M	String	U_Of_M	8
35	ATYALLOC	QTY Allocated	Currency	DLR17_QTY_RBS0_UTR	17
36	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
37	QTY_ISSUED_I	QTY Issued	Currency	DLR17_QTY_RBS0_UTR	17
38	QTY_BACKFLUSHED_I	QTY Backflushed	Currency	DLR17_QTY_RBS0_UTR	17
39	ITEMDESC	Item Description	String	STR100	100
40	LINK_TO_SEQUENCE_I	Link To Sequence	Long Integer	LINT_10	10
41	FIXED_QTY_I	Fixed Quantity	Currency	DLR17_QTY_RBS0_UTR	17
42	LEADTIMEOFFSET_I	Lead Time Offset	Currency	DLR_10_3	18
43	OFFSET_FROM_I	Offset From	Integer	DDL_Offset_From	0
44	BOMUSERDEF1_I	BOM User Def1	String	STR30	30
45	BOMUSERDEF2_I	BOM User Def2	String	STR_30	30
46	BOMSEQ_I	BOM Seq	Long Integer	LINT_10	10
47	QTYREMAI	QTY Remaining	Currency	DLR17_QTY_RBS0_UTR	17

azurecurve Products Manufacturing (346)3rd PartyPicklist File (EXPV1003)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply