ASN_LINES

Name: ASN_LINES
Creator: Ryan Brents
License: https://creativecommons.org/licenses/by/4.0/

ASN Lines

tableFINASN

ASN_LINES — ASN Lines. FIN table in the standard Ross ERP 8.0 schema: 110 columns, used by 8 programs. Columns, data types, keys, foreign keys and relationships.

Open ASN_LINES in the interactive Data Dictionary →

Part of Other tables & objects · all tables, views & procedures

Columns

#	Column	Type	Description
1	GEM_DBKEY	int	GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2	ASN_OPCODE	varchar(1)	ASN Op Code
3	ASN_ID	varchar(35)	ASN ID
4	ASN_SEQUENCE_NUMBER	smallint	ASN Sequence Number
5	ASN_SHIP_FROM_PARTY_NODE_ID	varchar(35)	ASN Ship From Party Node ID
6	ASN_LINE_NBR	int	ASN Line Number
7	ASN_LINE_SEQ_NBR	int	ASN Line Sequence Number
8	ASN_ORIG_PO_LINE_POSITION	varchar(16)	ASN Original PO Line Position
9	ASN_ORIG_PO_LINE_SEQ	smallint	ASN Original PO Line Sequence
10	ASN_ORIG_CUSTOMER_REF	varchar(35)	ASN Original Customer Reference
11	ASN_INVENTORY_STATUS_CODE	varchar(5)	ASN Inventory Status Code
12	ASN_INVENTORY_STATUS_DAYS	int	ASN Inventory Status Days
13	ASN_INVENTORY_STATUS_KEY	varchar(12)	ASN Inventory Status Key
14	ASN_INVENTORY_STATUS_TEXT	varchar(200)	ASN Inventory Status Text
15	ASN_INVENTORY_STATUS_ADATE	datetime	ASN Inventory Status Alarm Date
16	ASN_INSTRUCTIONS	varchar(400)	ASN Instructions
17	ASN_PREDEF_ITEM_LOAD_ID	varchar(35)	ASN Predefined Item Load ID
18	ASN_PRODUCT_SHIP_FROM	varchar(35)	ASN Product Number Ship From Partner
19	ASN_PRODUCT_SHIP_TO	varchar(35)	ASN Product Number Ship To Partner
20	ASN_GLOBAL_PRODUCT_NBR	varchar(35)	ASN Global Product Number
21	ASN_ADD_PACKING_MATERIAL	varchar(1)	ASN Additional Packing Material
22	ASN_CUSTOMER_ORDER_TYPE	varchar(2)	ASN Customer Order Type
23	ASN_PO_NUMBER	varchar(35)	ASN PO Number
24	ASN_PO_SEQUENCE	smallint	ASN PO Sequence
25	ASN_PO_LINE_POS	smallint	ASN PO Line Pos
26	ASN_PO_LINE_SEQ	smallint	ASN PO Line Sequence
27	ASN_STOCK_PROD_NBR	varchar(35)	ASN Stocked Product Number
28	ASN_GLOBAL_STOCK_PROD_NBR	varchar(35)	ASN Global Product Number
29	ASN_FROM_PARTY_ID	varchar(17)	ASN From Party ID
30	ASN_FROM_PARTY_QF	varchar(3)	ASN From Party Qualifier
31	ASN_CUST_RET_ORDER_NBR	varchar(35)	ASN Customer Return Order Number
32	ASN_CUST_RET_ORDER_SEQ	smallint	ASN Customer Return Order Sequence
33	ASN_CUST_RET_ORDER_LINE_POS	int	ASN Customer Return Order Line Pos
34	ASN_CUST_RET_ORDER_KIT_POS	smallint	ASN Customer Return Order Line Kit Pos
35	ASN_CUST_RET_ORDER_LINE_SEQ	smallint	ASN Customer Return Order Line Sequence
36	ASN_ACTION_CODE	varchar(2)	ASN Action Code
37	ASN_ACTION_CODE_REQ	varchar(1)	ASN Action Code Requirement
38	ASN_REASON_CODE	varchar(2)	ASN Reason Code
39	ASN_REASON_TEXT	varchar(400)	ASN Reason Text
40	ASN_SHIP_TO_VENDOR_ID	varchar(17)	ASN Ship To Vendor ID
41	ASN_SHIP_TO_VENDOR_QF	varchar(3)	ASN Ship To Vendor Qualifier
42	ASN_DISCREP_QTY	numeric(10,2)	ASN Discrepancy Qty
43	ASN_DISCREP_CODE	varchar(3)	ASN Discrepancy Code
44	ASN_DISCREP_TEXT	varchar(35)	ASN Discrepancy Text
45	ASN_LOAD_CARRIER_ID	varchar(35)	ASN Load Carrier ID
46	ASN_SHIP_FROM_PARTY_ID	varchar(17)	ASN Ship From Party ID
47	ASN_SHIP_TO_PARTY_NODE_ID	varchar(35)	ASN Ship To Party Node ID
48	ASN_SHIP_TO_PARTY_ID	varchar(17)	ASN Ship To Party ID
49	ASN_SHIP_TO_PARTY_QF	varchar(3)	ASN Ship To Party Qualifier
50	ASN_SHIP_TO_CUST_NODE_ID	varchar(35)	ASN Ship To Customer Node ID
51	ASN_SHIP_TO_CUST_ID	varchar(17)	ASN Ship To Cust ID
52	ASN_SHIP_TO_CUST_QF	varchar(3)	ASN Ship To Cust Qualifier
53	ASN_SELL_TO_CUST_ID	varchar(17)	ASN Sell To Customer ID
54	ASN_SELL_TO_CUST_QF	varchar(3)	ASN Sell To Cust Qualifier
55	ASN_OWNER_ID	varchar(17)	ASN Owner ID
56	ASN_OWNER_ID_SHIP_TO_CUST	varchar(17)	ASN Owner ID Ship To Customer
57	ASN_VENDOR_ID	varchar(35)	ASN Vendor ID
58	ASN_VENDOR_PARTY_NODE_ID	varchar(35)	ASN Vendor Party Node ID
59	ASN_PRODUCT_NBR	varchar(35)	ASN Product Number
60	ASN_PRODUCT_DESC	varchar(35)	ASN Product Description
61	ASN_PRODUCT_NBR_TYPE	varchar(1)	ASN Product Number Type
62	ASN_ALT_PRODUCT_NBR	varchar(35)	ASN Alternate Product Number
63	ASN_ALT_PRODUCT_DESC	varchar(35)	ASN Alternate Product Description
64	ASN_PRODUCT_DATE	datetime	ASN Product Date
65	ASN_EXPIRY_DATE	datetime	ASN Expiry Date
66	ASN_MANU_DATE	datetime	ASN Manufacturing Date
67	ASN_VENDOR_PRODUCT_NBR	varchar(35)	ASN Vendor Product Number
68	ASN_PURCHASE_PRICE	numeric(20,7)	ASN Purchase Price
69	ASN_PACKAGE_ID	varchar(35)	ASN Package ID
70	ASN_PRODUCTION_LOT_ID	varchar(40)	ASN Production Lot ID
71	ASN_PRODUCTION_SUBLOT_ID	varchar(40)	ASN Production Sub-Lot ID
72	ASN_MANUFACTURING_UNIT	varchar(20)	ASN Manufacturing Unit
73	ASN_MARKETING_LOT_ID	varchar(20)	ASN Marketing Lot ID
74	ASN_SERIAL_NBR	varchar(21)	ASN Serial Number
75	ASN_STORAGE_LOT	varchar(20)	ASN Storage Lot
76	ASN_SHIPPED_QTY	numeric(20,2)	ASN Shipped Quantity
77	ASN_MEASURED_QTY	numeric(20,3)	ASN Measured Quantity
78	ASN_MEASURE_QF	varchar(3)	ASN Measure Qualifier
79	ASN_VOLUME	numeric(20,6)	ASN Volume
80	ASN_VOLUME_UOM_ID	varchar(4)	ASN Volume UOM ID
81	ASN_WEIGHT	numeric(20,6)	ASN Weight
82	ASN_WEIGHT_UOM_ID	varchar(17)	ASN Weight UOM ID
83	ASN_CUST_ORDER_NBR	varchar(35)	ASN Customer Order Number
84	ASN_CUST_ORDER_SEQ	smallint	ASN Customer Order Sequence
85	ASN_CUST_ORDER_LINE_POS	int	ASN Customer Order Line Position
86	ASN_CUST_ORDER_LINE_SEQ	int	ASN Customer Order Line Sequence
87	ASN_CUST_ORDER_KIT_POS	smallint	Customer Order Line Kit Position
88	ASN_ORIG_PO_NBR	varchar(35)	ASN Original PO Number
89	ASN_ORIG_PO_SEQ	smallint	ASN Original PO Sequence
90	COUNTRY_CODE	varchar(6)	Country Code
91	FIFO_DATE	datetime
92	RELEASE_DATE	datetime	Job Release Date
93	CUSTOMER_DEPARTMENT	int
94	ASN_ITEM_UDEF_A	varchar(50)
95	ASN_ITEM_UDEF_B	varchar(50)
96	ASN_ITEM_UDEF_C	varchar(50)
97	ASN_ITEM_UDEF_D	varchar(50)
98	ORIG_ASN_ID	varchar(35)
99	ITEM_WEIGHT	numeric(20,4)
100	ITEM_LENGTH	numeric(20,4)
101	ITEM_WIDTH	numeric(20,4)
102	ITEM_HEIGHT	numeric(20,4)
103	CASE_QUANTITY	numeric(20,6)
104	RECEIVED_QUANTITY	numeric(20,6)	Received Quantity
105	ALLOCATED_QUANTITY	numeric(20,6)
106	PRINT_QUANTITY	numeric(20,6)
107	DELIVERY_QUANTITY	numeric(20,6)
108	DELIVERY_LINE	varchar(35)
109	SERIAL_NUMBER	varchar(50)
110	RECEIVED_FLAG	varchar(1)