A_DESPATCH_NOTES

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

Archived Despatch Notes

tableFINDESPATCH

A_DESPATCH_NOTES — Archived Despatch Notes. FIN table in the standard Ross ERP 8.0 schema: 123 columns, used by 10 programs. Columns, data types, keys, foreign keys and relationships.

Open A_DESPATCH_NOTES in the interactive Data Dictionary →

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

Columns

#	Column	Type	Key	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	ARCHIVE_ID	varchar(1)	PK	Prefix Fields for Archive Tables
3	COMPANY_CODE	varchar(10)	PK	Company Code
4	DIVISION	varchar(2)	PK	Division
5	DESPATCH_NUMBER	int		Ship Run Number
6	DESPATCH_SEQUENCE	smallint		Ship Sequence Number
7	DESPATCH_NOTE	int	PK	Shipping Note
8	DESPATCH_LINE	int	PK	Ship Note Line Number
9	DATE_CREATED	datetime		Date Created
10	PICK_LIST_NUMBER	int		Pick List Run Number
11	PICK_LINE	int		Picking Line Number
12	ORDER_NUMBER	varchar(9)		Order Number
13	ORDER_LINE_NUMBER	int		Order Line Number
14	SEQUENCE	smallint		Sequence Number
15	ORDER_DATE	datetime		Order Date
16	REQUIRED_DATE	datetime		Required Date
17	PROMISED_DATE	datetime		Promised Date
18	CUSTOMER_NUMBER	varchar(8)		Customer Number
19	LOCATION	varchar(8)		Location
20	DELIVERY_ADDRESS_CODE	varchar(10)		Delivery Address Code
21	SALESPERSON_CODE	varchar(8)		Salesperson Code
22	SALES_ANALYSIS_GROUP	varchar(8)		Sales Analysis Group Code
23	UNIT_SALES	varchar(4)		Unit of Measure (Sales)
24	SALES_PRICE	numeric(20,4)		Standard Sales Price
25	NONSTOCK	varchar(1)		Non-Stock Prod
26	NONSTOCK_DESCRIPTION	text
27	PART_CODE	varchar(15)		Product
28	WAREHOUSE	varchar(2)		Warehouse Code
29	BIN_LOCATION	varchar(15)		Bin Location
30	PERIOD	smallint		Period Number
31	YEAR	smallint		Year Number
32	PICKING_VALUE	numeric(20,2)		Picking Value
33	BATCH_FLAG	varchar(1)		Batch Flag
34	BIN_SIZING	varchar(1)		Bin Sizing In Effect
35	CONFIRM_DESPATCH	varchar(1)		Confirm Ship Note Line
36	NOTES	text		Notes
37	BATCHES_AT_DESPATCH_CONFIRM	varchar(1)		Lots required at Ship Amend
38	STATUS_FLAG	varchar(1)		Status Flag
39	DESPATCH_VALUE	numeric(20,2)		Shipping Value
40	PRINT_FLAG	varchar(1)		Print Flag
41	COST_OF_SALE	numeric(20,2)		Cost Of Sale
42	INVOICE_ADDRESS_CODE	varchar(10)		Invoice Address Code
43	WEIGHT	numeric(20,4)		Weight of Product
44	WEIGHT_UOM	varchar(4)		Weight Unit of Measure
45	VOLUME	numeric(20,4)		Total Volume (cubic size)
46	VOLUME_UOM	varchar(4)		Volume Unit of Measure
47	CREDIT_STATUS_CODE	varchar(6)		Credit Status Code
48	WAREHOUSED_FLAG	varchar(1)		Warehoused Product Y/N
49	OLD_BIN_LOCATION	varchar(15)
50	ORDER_CYCLE	varchar(1)		Order Cycle
51	MH_NUMBER	int		Material Handling Number
52	OLD_MH_NUMBER	int
53	DESPATCH_DATE	datetime		Ship Date
54	LINE_SENT_FOR_DESPATCH	varchar(1)
55	DATA_CAPTURE_CONFIRM	varchar(1)		Data Capture Confirm
56	SYS_PRINT_PART_DETAIL	varchar(1)		Print product detail flag
57	SYS_CURRENCY_CODE	varchar(6)		Currency Code
58	SYS_CURRENCY_RATE	numeric(20,12)		Currency Rate
59	SYS_RATE_TYPE	varchar(6)		Currency Rate Type
60	SYS_RATE_AUTHORITY	varchar(6)		Currency Rate Authority
61	SYS_CURRENCY_FIXED_FLAG	varchar(1)		Currency Rate Fixed Flag
62	SYS_BASE_CURRENCY	varchar(6)
63	SYS_CURRENCY_RATIO_INDIC	varchar(1)		Ratio Indicator
64	SYS_EC_PROCESSED_INDICATOR	varchar(1)		EC Tax Process Indicator
65	SYS_TARIFF_CODE	varchar(11)		Tariff Code
66	SYS_EC_MODE_OF_TRANSPORT	varchar(1)		EC Mode of Transport
67	SYS_EC_DELIVERY_TERMS	varchar(3)		EC Delivery Terms
68	SYS_EC_STATISTICS_APPLICABLE	varchar(1)		EC Statistics Applicable
69	SYS_EC_WEIGHT	numeric(20,0)		Weight
70	SYS_EC_SUPP_UNIT_QTY	numeric(20,6)		Supplementary Unit Qty
71	SYS_COUNTRY_OF_ORIGIN	varchar(6)
72	SYS_EC_TRANSACTION_TYPE	varchar(2)		EC Nature of Transaction
73	IC_LOT_NUMBER	varchar(20)		Lot Number
74	IC_LOT_SEQUENCE	int		Lot Sequence
75	IC_OLD_LOT_NUMBER	varchar(20)
76	IC_OLD_LOT_SEQUENCE	int
77	SYS_CURRENCY_DATE	datetime		Currency Date
78	DELIVERY_INSTRUCTIONS	varchar(30)		Delivery Instructions
79	SHIP_METHOD	varchar(10)		Method of Shipment
80	SYS_EC_ANALYSIS_1	varchar(10)		EC Analysis Code 1
81	SYS_EC_ANALYSIS_2	varchar(10)		EC Analysis Code 2
82	SYS_EC_ANALYSIS_3	varchar(10)		EC Analysis Code 3
83	SYS_EC_ANALYSIS_4	varchar(10)		EC Analysis Code 4
84	SYS_EC_ANALYSIS_5	varchar(10)		EC Analysis Code 5
85	SYS_EC_STATISTICAL_VALUE	numeric(20,2)		EC Statistical Value
86	PICKING_VALUE_BASE	numeric(20,2)		Picking Value in Base
87	DESPATCH_VALUE_BASE	numeric(20,2)		Ship Value in Base
88	SYS_SORT_FILLER	varchar(1)		dummy field to fill sort sequence
89	IC_PACK_UNIT	varchar(4)		Packaged Unit Of Measure
90	SOP_NOMINATED_UNIT	varchar(4)		Inventory unit which Sales unit converts to
91	IC_OTHER_INVENTORY_UNIT	varchar(4)		Other Inventory UOM
92	UNIT_COST	numeric(20,6)		Unit Cost
93	AR_DRAFT_PAYMENT_TYPE	varchar(3)
94	SYS_SHIPPING_DATE	datetime		Shipping Date
95	AP_DIVISION	varchar(2)		Division
96	TM_LOAD_NUMBER	varchar(9)		Transport load number
97	SHIPPING_REQUIREMENT_NUMBER	smallint		Shipping Requirements number
98	SHIPPING_LEG	smallint		Shipping leg sequence number
99	SOP_SHIPPING_LIST_LINE	smallint		Line sequence number on Final Shipping List
100	SHIPMENT_SPLIT_SEQUENCE	smallint
101	SOP_LOAD_ID	smallint		Shipment load ID
102	SOP_DESTINATION_WAREHOUSE	varchar(2)
103	SOP_CLOSE_ORDER	varchar(1)		Close Order Flag - Order filled
104	SOP_SHIPPING_TERMS_CODE	varchar(8)
105	CREDIT_TERMS_CODE	varchar(6)		Credit Terms Code
106	UNIT_PRICE	varchar(4)		Unit of Measure (Pricing)
107	SOP_LOAD_WEIGHT	numeric(20,4)
108	TM_INVOICE_SHIPPING_RUN	int
109	TM_INVOICE_LOAD_ID	smallint
110	TM_POD_DATE	datetime		POD Date
111	TM_RELEASE_TO_INVOICE	varchar(1)		Release Ship Note or Manual Invoice to Invoicing
112	TM_LOAD_PLANNING	varchar(1)		Indicates whether load planning is in use.
113	SOP_SHIPPING_RUN_NUMBER	int		Shipping Run Number
114	SYS_CURRENCY_2_RATE	numeric(20,12)		Second Base Currency Rate
115	SYS_RATE_2_TYPE	varchar(6)		Second Base Currency Rate Type
116	SYS_RATE_2_AUTHORITY	varchar(6)		Second Base Currency Rate Authority
117	SYS_CURRENCY_2_FIXED_FLAG	varchar(1)		Currency Rate Fixed
118	SYS_CURRENCY_2_RATIO_INDIC	varchar(1)		Ratio Indicator for Second Base
119	ARCHIVE_DATE	datetime		Archive Date
120	ARCHIVE_USERNAME	varchar(20)		Username recorded when the row was moved to the archive.
121	MP_INVOICE_CUSTOMER	varchar(8)		Invoice Customer
122	MP_SHIPPING_CUSTOMER	varchar(8)		Shipping Customer
123	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.