ASN_HEADERS
ASN Headers
tableFINASN
ASN_HEADERS — ASN Headers. FIN table in the standard Ross ERP 8.0 schema: 37 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.
Open ASN_HEADERS 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 | 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_LEVEL | varchar(2) | ASN Level | |
| 7 | ASN_SHIP_DATE | datetime | Advanced ship notice ship date | |
| 8 | ASN_DOCUMENT_DATE | datetime | ASN Document Date Time | |
| 9 | ASN_DELIVERY_WINDOW_FIRST | datetime | ASN Delivery Window First | |
| 10 | ASN_DELIVERY_WINDOW_LAST | datetime | ASN Delivery Window Last | |
| 11 | ASN_REQUESTED_ARRIVAL_DATE | datetime | ASN Requested Arrival Date | |
| 12 | ASN_SCHEDULED_ARRIVAL_DATE | datetime | ASN Scheduled Arrival Date | |
| 13 | ASN_SHIP_FROM_PARTY_ID | varchar(17) | ASN Ship From Party ID | |
| 14 | ASN_SHIP_FROM_PARTY_QF | varchar(3) | ASN Ship From Party Qualifier | |
| 15 | ASN_SHIP_TO_PARTY_NODE_ID | varchar(35) | ASN Ship To Party Node ID | |
| 16 | ASN_SHIP_TO_PARTY_ID | varchar(17) | ASN Ship To Party ID | |
| 17 | ASN_SHIP_TO_PARTY_QF | varchar(3) | ASN Ship To Party Qualifier | |
| 18 | ASN_FORWARDER_ID | varchar(8) | ASN Forwarder Identity | |
| 19 | ASN_NUMBER_OF_LOAD_CARRIERS | int | ASN Number of Load Carriers | |
| 20 | ASN_VEHICLE_ID | varchar(15) | ASN Vehicle ID | |
| 21 | ASN_ESTIMATED_VOLUME | numeric(20,4) | ASN Estimated Volume | |
| 22 | ASN_VOLUME_UOM_ID | varchar(4) | ASN Volume UOM ID | |
| 23 | ASN_BILL_OF_LADING_NUMBER | varchar(30) | ASN Bill of Lading Number | |
| 24 | ASN_PACKINGSLIP_NUMBER | varchar(35) | ASN Packing Slip Number | |
| 25 | ASN_SHIPPED_FROM_WH_ID | varchar(2) | ASN Shipped From Warehouse ID | |
| 26 | ASN_SHIPPED_ON_DEPARTURE_ID | varchar(35) | ASN Shipped on Departure ID | |
| 27 | ASN_INSTRUCTIONS | varchar(400) | ASN Instructions | |
| 28 | PACK_STRUCTURE | int | ||
| 29 | ORIG_PACK_STRUCTURE | int | ||
| 30 | VENDOR_SHIPMENT_LOCATION | varchar(35) | ||
| 31 | POR_NUMBER | varchar(50) | ||
| 32 | OWNER_ID | varchar(35) | ||
| 33 | ASN_HEADER_UDEF_A | varchar(50) | ||
| 34 | ASN_HEADER_UDEF_B | varchar(50) | ||
| 35 | ASN_HEADER_UDEF_C | varchar(50) | ||
| 36 | ASN_HEADER_UDEF_D | varchar(50) | ||
| 37 | ASN_CLOSE_DATE | datetime |