OM_EXPORT_DOC(SQL Table) |
Index Back |
|---|---|
Table for OM Export Doc's.Date Initials Issue # Description 120800 dms SP2 (DI-EDWONG-12) Add Language Code |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | BILL_OF_LADING |
Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 3 | BOL_LINE_NO |
Number(2,0) | SMALLINT NOT NULL | Bill Of Lading Line Number |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID |
| 6 | CARR_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Carrier Descr |
| 7 | CARR_ADDRESS1 | Character(35) | VARCHAR2(35) NOT NULL | Carrier Address 1 |
| 8 | CARR_ADDRESS2 | Character(35) | VARCHAR2(35) NOT NULL | Carrier Address 2 |
| 9 | CARR_ADDRESS3 | Character(35) | VARCHAR2(35) NOT NULL | Carrier Address 3 |
| 10 | CARR_ADDRESS4 | Character(35) | VARCHAR2(35) NOT NULL | Carrier Address 4 |
| 11 | CARR_NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 12 | CARR_NUM2 | Character(4) | VARCHAR2(4) NOT NULL | Number 2 |
| 13 | CARR_HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 14 | CARR_CITY | Character(30) | VARCHAR2(30) NOT NULL | Carrier City |
| 15 | CARR_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | Carrier County |
| 16 | CARR_STATE | Character(6) | VARCHAR2(6) NOT NULL | Carrier State |
| 17 | CARR_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Carrier Postal |
| 18 | CARR_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Carrier Country |
| 19 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 20 | COMMODITY_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Commodity Descr |
| 21 | CONSIGNEE_INTM | Character(10) | VARCHAR2(10) NOT NULL | Intermediate Consignee |
| 22 | CONS_INTM_NAME | Character(35) | VARCHAR2(35) NOT NULL | Intermediate Consignee Name |
| 23 | CONSIGNEE_ULTM | Character(15) | VARCHAR2(15) NOT NULL | Ultimate Consignee |
| 24 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer PO |
| 25 | ULT_NAME | Character(35) | VARCHAR2(35) NOT NULL | Ultimate Consignee Name |
| 26 | ULT_ADDRESS1 | Character(35) | VARCHAR2(35) NOT NULL | Address 1 |
| 27 | ULT_ADDRESS2 | Character(35) | VARCHAR2(35) NOT NULL | Address 2 |
| 28 | ULT_ADDRESS3 | Character(35) | VARCHAR2(35) NOT NULL | Address 3 |
| 29 | ULT_ADDRESS4 | Character(35) | VARCHAR2(35) NOT NULL | Address 4 |
| 30 | ULT_NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 31 | ULT_NUM2 | Character(4) | VARCHAR2(4) NOT NULL | Number 2 |
| 32 | ULT_HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 33 | ULT_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 34 | ULT_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 35 | ULT_STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 36 | ULT_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 37 | ULT_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 38 | ULT_TAXPAYER_ID | Character(14) | VARCHAR2(14) NOT NULL | Ult. Taxpayer ID |
| 39 | CONTAINERIZED | Character(1) | VARCHAR2(1) NOT NULL | Containerized |
| 40 | COUNTRY_DEST | Character(3) | VARCHAR2(3) NOT NULL | Country of Destination |
| 41 | DRIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Driver ID |
| 42 | EIN_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | Exporter's EIN Number |
| 43 | EXPORTER | Character(10) | VARCHAR2(10) NOT NULL | Exporter |
| 44 | EXP_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Export Descr |
| 45 | EXP_ADDRESS1 | Character(35) | VARCHAR2(35) NOT NULL | Address 1 |
| 46 | EXP_ADDRESS2 | Character(35) | VARCHAR2(35) NOT NULL | Address 2 |
| 47 | EXP_ADDRESS3 | Character(35) | VARCHAR2(35) NOT NULL | Address 3 |
| 48 | EXP_ADDRESS4 | Character(35) | VARCHAR2(35) NOT NULL | Address 4 |
| 49 | EXP_NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 50 | EXP_NUM2 | Character(4) | VARCHAR2(4) NOT NULL | Number 2 |
| 51 | EXP_HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 52 | EXP_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 53 | EXP_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 54 | EXP_STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 55 | EXP_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 56 | EXP_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 57 | EXP_TAXPAYER_ID | Character(14) | VARCHAR2(14) NOT NULL | Taxpayer ID |
| 58 | EXPORT_DATE | Date(10) | DATE | Export Date |
| 59 | EXPORTER_ECCN | Character(16) | VARCHAR2(16) NOT NULL | Export Cntl Classification Nbr |
| 60 | EXPORT_LIC_NBR | Character(18) | VARCHAR2(18) NOT NULL | Export License Nbr |
| 61 | FOREIGN_DOMESTIC | Character(1) | VARCHAR2(1) NOT NULL |
Bill of Lading Type
B=Foreign and Domestic D=Domestic F=Foreign |
| 62 | FORWARDING_AGENT | Character(10) | VARCHAR2(10) NOT NULL | Forwarding Agent |
| 63 | FA_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Forwarding Agent Descr |
| 64 | FOR_OR_DOM_GOODS | Character(1) | VARCHAR2(1) NOT NULL |
Foreign or Domestic Goods
D=Domestic F=Foreign |
| 65 | FRT_FORWARD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Freight Forwarder
Y/N Table Edit |
| 66 | HARMONIZED_CD | Character(14) | VARCHAR2(14) NOT NULL | Harmonized Code |
| 67 | HARMONIZED_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Harmonized Descr |
| 68 | LOADING_PIER | Character(10) | VARCHAR2(10) NOT NULL | Loading Pier |
| 69 | NET_COST | Character(2) | VARCHAR2(2) NOT NULL | Net Cost |
| 70 | NET_UNIT_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price |
| 71 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 72 | PACKING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Packing Weight |
| 73 | PACKING_WEIGHT_KG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Packing Weight KG |
| 74 | POINT_OF_ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Point of Origin |
| 75 | POINT_ORIGIN_ST | Character(6) | VARCHAR2(6) NOT NULL | Point of Origin State |
| 76 | PORT_OF_EXPORT | Character(10) | VARCHAR2(10) NOT NULL | Port Of Export |
| 77 | PORT_OF_UNLOADING | Character(10) | VARCHAR2(10) NOT NULL | Port Of Unloading |
| 78 | QTY_SHIPPED_CONV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
| 79 | ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. |
| 80 | SEAL_NUMBER | Character(16) | VARCHAR2(16) NOT NULL | Seal Number |
| 81 | SHIPPING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 82 | SHIPPING_WEIGHT_KG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight KG |
| 83 | TRANSPORT_MODE | Character(10) | VARCHAR2(10) NOT NULL | Mode of Transport |
| 84 | TRANS_PARTIES | Character(1) | VARCHAR2(1) NOT NULL |
Parties to Transaction
N=Non-Related R=Related |
| 85 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |
| 86 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 87 | VEHICLE_ID | Character(10) | VARCHAR2(10) NOT NULL | Vehicle ID |
| 88 | PREF_CRITERION | Character(3) | VARCHAR2(3) NOT NULL | Preference Criterion |
| 89 | PRODUCER | Character(1) | VARCHAR2(1) NOT NULL |
Producer
1=NO(1) 2=NO(2) 3=NO(3) 4=YES |
| 90 | SETTLE_CURR | Character(3) | VARCHAR2(3) NOT NULL | Curr Settle |