CARRIER_ID

(SQL Table)
 Index Back

Carrier Address Table

Carrier Address Table

  • Related Language Record: CARRIER_ID_LANG

  • Parent Record Of CARRIER_ID_LNG CARRIER_ID_VW CARRIER_ID_VW2 CARRIER_LV CARRIER_LVW HWB_CARRIER_LVW IN_CARRIEREX_LV IN_CARRIER_LNVW ORDENT_CARR_VW PRC_CARRIERX_LV PRC_CARRIER_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
    7 NETWORK_ID Character(18) VARCHAR2(18) NOT NULL Network ID
    8 FRT_FORWARD_FLG Character(1) VARCHAR2(1) NOT NULL Freight Forwarder

    Y/N Table Edit

    Default Value: N

    9 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
    10 ALT_NAME2 Character(40) VARCHAR2(40) NOT NULL Alternate Name 2
    11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPTIONS.LANGUAGE_CD

    12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    15 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    17 CITY Character(30) VARCHAR2(30) NOT NULL City
    18 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    19 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    20 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    21 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    22 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    23 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    24 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    25 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    27 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    28 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    29 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    30 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    31 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
    32 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    33 LAST_EXP_CHK_DTTM DateTime(26) TIMESTAMP Last Date/Time Export Comp Chk
    34 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    35 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
    36 PRO_NUMBER_URL Character(200) VARCHAR2(200) NOT NULL Created 07/22/1999 Eddie Timbang.
    37 PRO_NUMBER_URL_SUF Character(200) VARCHAR2(200) NOT NULL Created on 07/22/1999 by Eddie Timbang
    38 ORD_NUMBER_URL Character(200) VARCHAR2(200) NOT NULL Created on 07/22/1999 by Eddie Timbang
    39 ORD_NUMBER_URL_SUF Character(200) VARCHAR2(200) NOT NULL Created on 07/22/1999 by Eddie Timbang
    40 FREIGHT_VENDOR Character(1) VARCHAR2(1) NOT NULL Used by OM, INV.
    E=External Freight System
    I=Internal Freight System

    Default Value: I

    41 INTERLINK_DLL Character(100) VARCHAR2(100) NOT NULL Interlink DLL Name
    42 TMS_EXCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL Exclude From TMS Extract

    Y/N Table Edit

    Default Value: N

    43 IN_DFR_DPL_DFLT Character(1) VARCHAR2(1) NOT NULL Defer Depletions default flag
    1=Default Defer Depletions to Y
    2=Default Defer Depletions to N
    3=Use Business Unit Dflt Value

    Default Value: 3