DC_LICENSE_PLATE_HISTORY

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

DC License Plate History

tableFINDC

DC_LICENSE_PLATE_HISTORY — DC License Plate History. FIN table in the standard Ross ERP 8.0 schema: 64 columns, used by 13 programs. Columns, data types, keys, foreign keys and relationships.

Open DC_LICENSE_PLATE_HISTORY in the interactive Data Dictionary →

Part of DC 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	SYS_REVISED_DATE_TIME	datetime	Revised Date Time
3	USER_ID	varchar(20)	User Identification Code
4	FACILITY_ID	varchar(50)	Facility Id
5	UPDATE_ACTION	varchar(30)
6	DC_TRANSACTION_ID	varchar(64)	Data Collection (RF/mobile) transaction identifier for the row.
7	COMPANY_CODE	varchar(10)	Company Code
8	DC_LICENSE_PLATE_ID	varchar(30)	Data Collection License Plate ID
9	WAREHOUSE	varchar(2)	Warehouse Code
10	BIN_LOCATION	varchar(15)	Bin Location
11	DC_EQUIPMENT_TARE_WEIGHT	numeric(20,4)
12	DC_EQUIPMENT_TARE_UNIT	varchar(4)
13	DC_LICENSE_PLATE_STATUS	varchar(10)	Data Collection License Plate Status
14	DC_PARENT_LICENSE_PLATE_ID	varchar(30)
15	DC_ASN_LOAD_CARRIER_TYPE	varchar(3)	Load Carrier Type
16	WH_XFER_DOC_REFERENCE	varchar(15)
17	DC_LICENSE_PLATE_LINE	smallint	Data Collection License Plate Line
18	PART_CODE	varchar(15)	Product
19	IC_LOT_NUMBER	varchar(20)	Lot Number
20	MH_NUMBER	int	Material Handling Number
21	IC_STATUS_CODE	varchar(8)	Inventory Status
22	QUANTITY_1	numeric(20,6)	Original Quantity
23	COUNT_QUANTITY_1	numeric(20,6)
24	UOM_1	varchar(4)
25	QUANTITY_2	numeric(20,6)	Original Quantity
26	COUNT_QUANTITY_2	numeric(20,6)
27	UOM_2	varchar(4)
28	DOC_REFERENCE	varchar(15)	Document Reference
29	DOC_LINE	smallint
30	PHYS_COUNT_NUMBER	int	Count Number
31	COUNT_SEQ_NUMBER	int	Inventory Count Sequence Number
32	DC_TARE_WEIGHT_1	numeric(20,4)
33	DC_TARE_WEIGHT_2	numeric(20,4)
34	DC_TARE_UNIT	varchar(4)
35	AR_DIVISION	varchar(2)
36	DESPATCH_NOTE	int	Shipping Note
37	DESPATCH_LINE	int	Ship Note Line Number
38	AP_DIVISION	varchar(2)	Division
39	GRN_NUMBER	varchar(9)	Goods Received Note Number
40	GRN_LINE_NUMBER	int	Goods Received Note Line Number
41	FACTORY	varchar(2)	Factory Code
42	JOB_NUMBER	varchar(10)	Job Number
43	PROCESS_STAGE	varchar(6)	Process Stage
44	COUNT_SEQ	smallint	Count Sequence
45	SOURCE_MODULE	varchar(2)	Source Module Reference
46	CREDIT_NOTE_NUMBER	int	Credit Note Number
47	CREDIT_NOTE_LINE_NUMBER	int	Credit Note Line Number
48	ORIG_BIN_LOCATION	varchar(15)
49	ORIG_SOURCE_MODULE	varchar(2)
50	ORIGINAL_DOCUMENT_NUMBER	varchar(13)	Original Document Number
51	ORIGINAL_DOCUMENT_LINE	varchar(8)	Original Document Line
52	ORIGINAL_DOCUMENT_SEQUENCE	smallint	Original Document Sequence
53	COUNT_WAREHOUSE	varchar(2)
54	WOM_WO_ID	numeric(20,0)	Work Order
55	WOL_WO_LN_NUM	numeric(20,0)	WO Step Number
56	EQM_EQP_ID	varchar(20)	Equipment Id
57	CAM_ACCT_ID	varchar(20)	Charge Account Id
58	GEM_ARCHIVE_FLAG	varchar(20)	System flag indicating whether the row has been archived by the GEMBASE archive process.
59	SOURCE_WAREHOUSE	varchar(2)
60	INVOICE_NUMBER	int	Invoice Number
61	INVOICE_LINE_NUMBER	int	Invoice Line Number
62	INVOICE_SEQUENCE	smallint
63	DC_CASE_SERIAL_NUMBER	varchar(30)
64	EAN_NUMBER	varchar(15)	GTIN