ASN_LOAD_CARRIERS
ASN Load Carriers
tableFINASN
ASN_LOAD_CARRIERS — ASN Load Carriers. FIN table in the standard Ross ERP 8.0 schema: 34 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.
Open ASN_LOAD_CARRIERS 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_LOAD_CARRIER_ID | varchar(35) | ASN Load Carrier ID | |
| 7 | ASN_LOAD_CARRIER_QF | varchar(4) | ASN Load Carrier Qualifier | |
| 8 | ASN_LOAD_CARRIER_TYPE | varchar(20) | ASN Load Carrier Type | |
| 9 | ASN_EXT_LOAD_CARRIER_TYPE | varchar(20) | ASN External Load Carrier Type | |
| 10 | ASN_PARENT_LOAD_CARRIER_ID | varchar(35) | ASN Parent Load Carrier ID | |
| 11 | ASN_PRODUCT_TRANSPORT_ID | varchar(5) | ASN Product Transport ID | |
| 12 | ASN_SHIP_FROM_PARTY_ID | varchar(17) | ASN Ship From Party ID | |
| 13 | ASN_SHIP_TO_PARTY_NODE_ID | varchar(35) | ASN Ship To Party Node ID | |
| 14 | ASN_SHIP_TO_PARTY_ID | varchar(17) | ASN Ship To Party ID | |
| 15 | ASN_SHIP_TO_PARTY_QF | varchar(3) | ASN Ship To Party Qualifier | |
| 16 | ASN_SHIP_TO_CUST_NODE_ID | varchar(35) | ASN Ship To Customer Node ID | |
| 17 | ASN_SHIP_TO_CUST_ID | varchar(17) | ASN Ship To Cust ID | |
| 18 | ASN_SHIP_TO_CUST_QF | varchar(3) | ASN Ship To Cust Qualifier | |
| 19 | ASN_INSTRUCTIONS | varchar(400) | ASN Instructions | |
| 20 | ASN_TOTAL_WEIGHT | numeric(20,6) | ASN Total Weight | |
| 21 | ASN_WEIGHT_UOM_ID | varchar(17) | ASN Weight UOM ID | |
| 22 | ASN_TOTAL_VOLUME | numeric(20,6) | ASN Total Volume | |
| 23 | ASN_VOLUME_UOM_ID | varchar(4) | ASN Volume UOM ID | |
| 24 | ASN_TOTAL_HEIGHT | numeric(20,4) | ASN Total Height | |
| 25 | ASN_HEIGHT_UOM_ID | varchar(17) | ASN Height UOM ID | |
| 26 | CATCH_WEIGHT | numeric(20,4) | ||
| 27 | TARE_EPC_ID | varchar(64) | ||
| 28 | PACK_EPC_ID | varchar(64) | ||
| 29 | CUSTOMER_NUMBER | varchar(8) | Customer Number | |
| 30 | ASN_PACK_UDEF_A | varchar(50) | ||
| 31 | ASN_PACK_UDEF_B | varchar(50) | ||
| 32 | ASN_PACK_UDEF_C | varchar(50) | ||
| 33 | ASN_PACK_UDEF_D | varchar(50) | ||
| 34 | AUDIT_FLAG | varchar(1) |