CUSTOMER

(SQL Table)
 Index Back

Customer Header Information

Note: Any field changes made to this record should also be made to CUSTOMER_SBR and the affected tables will need to be rebuilt. Date Init. Issue # Description 092697 Carina B. Made changes for related language display. 102000 Dino 5411901 Gromit 072401 JJM DI-EDWONG-17 Add Grants and Receivables fields 100901 JJM DI-EDWONG-17 Added CNTCT_SEQ_OPAC 102302 JJM F-C1ABANOS-25 Added FEDERAL_INDICATOR and TRADING_PARTNER fields 112202 KTW F-MULINAR-3 VAT on Services - Delete Vat fields 021706 EGS F-CJORG-I1BY7 Added OFAC_STATUS 120707 DEG 1672634003 Added GM fields 010708 PD Multiple PI feature Added couple of Grants fields 022808 KPS 1744817001 Removed the defaulted value for the field FED_SHARE_PCT

  • Related Language Record: CUSTOMER_LANG

  • Parent Record Of BI_ADDRSEQ_VW BI_SS_CUSEQ_VW CDT_CONV_DTL_VW CNVR_RECENT_VW CONVR_CLEAR_VW CONVR_RECENT_VW CORP_UPDT_TMP CUSTCPY_ADSEQ_V CUSTCPY_ASQ_LVW CUSTCPY_BILLO_V CUSTCPY_CRD_LVW CUSTCPY_CRED_VW CUSTCPY_RGNTY_V CUSTCPY_SHIPO_V CUSTCPY_SIC_VW CUSTCPY_SOLDO_V CUSTCPY_VAT_VW CUSTMST_ASEQ_VW CUSTMST_BOPT_VW CUSTMST_RGNT_VW CUSTTMP_ASQ_LVW CUSTTMP_BOPT_VW CUST_ADDR_SEQ CUST_ADDSEQ_EVW CUST_ADDSEQ_LVW CUST_AGREEMENT CUST_AGREE_VW CUST_ALLSHP_VW CUST_BLL_OPT_VW CUST_CNTCT_SEQ CUST_CONVER CUST_CREDIT CUST_CREDIT_LNG CUST_CREDIT_VW1 CUST_CRSPD CUST_CRSPD_BVW CUST_CRSPD_EVW CUST_CRSPD_REM CUST_DEFAULT_VW CUST_ID_NBRS CUST_OPTION CUST_OPTION_EVW CUST_PRENOTE CUST_REGN_TYPE CUST_SHIPTO_EVW CUST_SHIPTO_OPT CUST_SHPINV_VW CUST_SHPOPT_VW CUST_SIC_CODES CUST_SLD_OPT_VW CUST_SOLDTO_EVW CUST_SOLDTO_OPT CUST_VAT_EXCPTN CUST_VAT_REG CUST_VAT_RG_VW FO_CUST_PEAK FO_CUST_SALES GTA_CU_VAT_RGVW ORDENT_BOPT_VW ORDENT_CRED_VW PARENT_HIER_BAL WS_CUSTCRDT_LVW WS_CUST_CRDT_VW WS_CUST_OPTN_VW

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

    Prompt Table: SP_SETID_NONVW

    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: CUSTOMER

    3 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
    A=Active
    I=Inactive
    T=Template

    Default Value: A

    4 CUST_STATUS_DT Date(10) DATE Customer Status Date
    5 STCUST_DAYS Number(4,0) SMALLINT NOT NULL Days Until Expiration
    6 EXPIRATION_DATE Date(10) DATE Expiration Date
    7 EXP_PENDING Character(1) VARCHAR2(1) NOT NULL Expiration pending flag

    Default Value: N

    8 TEMPLATE_ADDR Character(1) VARCHAR2(1) NOT NULL Template Address Flag

    Y/N Table Edit

    Default Value: N

    9 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
    1=User 1
    2=User 2
    3=User 3
    4=User 4
    F=Foreign
    M=Commercial
    N=Consumer
    S=State and Local
    X=Excluded Foreign Customer

    Default Value: 1

    10 SINCE_DT Date(10) DATE NOT NULL Customer Since

    Default Value: %date

    11 ADD_DT Date(10) DATE NOT NULL Customer Added On

    Default Value: %date

    12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    13 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
    14 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    15 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
    16 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
    17 NAME2_AC Character(40) VARCHAR2(40) NOT NULL Name 2 Alternate Char Set
    18 NAME3_AC Character(40) VARCHAR2(40) NOT NULL Name 3 Alternate Char Set
    19 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: %EDITTABLE3

    20 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    21 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer

    Prompt Table: CUST_CC_A1S_VW

    22 PARENT_SETID Character(5) VARCHAR2(5) NOT NULL Parent SetID
    23 PARENT_CUST_ID Character(15) VARCHAR2(15) NOT NULL Parent Cust ID
    24 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    25 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer

    Prompt Table: CUST_REM_A1S_VW

    26 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    27 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

    Prompt Table: CUST_CR_A1S_VW

    28 CONSOL_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Specifies the Billing business unit associated with a consolidated bill.

    Prompt Table: BI_CONSOL_BU_VW

    29 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    30 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_AR2

    31 REFER_TO_SETID Character(5) VARCHAR2(5) NOT NULL Refer To Setid

    Prompt Table: SP_SETID_NONVW

    32 REFER_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Refer To Customer
    33 REVIEW_DAYS Number(3,0) SMALLINT NOT NULL Review Days
    34 FORMER_NAME_1 Character(40) VARCHAR2(40) NOT NULL Former Name 1
    35 FORMER_NAME_2 Character(40) VARCHAR2(40) NOT NULL Former Name 2
    36 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CONTACT

    37 SUBCUST_USE Character(1) VARCHAR2(1) NOT NULL SubCustomer

    Y/N Table Edit

    Default Value: N

    38 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

    Prompt Table: SUBCUST_Q1_TBL

    39 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

    Prompt Table: SUBCUST_Q2_TBL

    40 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Prompt Table: RT_TYPE_TBL

    41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    42 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL Ship To Customer
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    43 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL Bill To Customer
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    44 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL Sold To Customer

    Y/N Table Edit

    Default Value: N

    45 BROKER_FLG Character(1) VARCHAR2(1) NOT NULL Broker Customer

    Y/N Table Edit

    Default Value: N

    46 INDIRECT_CUST_FLG Character(1) VARCHAR2(1) NOT NULL Indirect Customer

    Y/N Table Edit

    Default Value: N

    47 CUST_LEVEL Character(1) VARCHAR2(1) NOT NULL Customer Level
    N=New
    P=Prospect
    R=Regular
    S=Short-Term
    T=Temporary

    Default Value: R

    48 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
    49 CNTCT_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Contact - Sold To
    50 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To
    51 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To
    52 ADDRESS_SEQ_BRK Number(5,0) INTEGER NOT NULL Primary Address - Broker
    53 ADDRESS_SEQ_IND Number(5,0) INTEGER NOT NULL Primary Address - Indirect
    54 HOLD_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Hold Update Switch

    Y/N Table Edit

    Default Value: N

    55 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

    Prompt Table: ROLEXLATOPR_VW

    56 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
    57 WEB_URL Character(130) VARCHAR2(130) NOT NULL Website URL
    58 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL Stock Symbol
    59 REPORTS_TO_SPONSOR Character(15) VARCHAR2(15) NOT NULL Reports To Sponsor

    Prompt Table: GM_CUSTOMER_VW

    60 SPNSR_LEVEL Character(4) VARCHAR2(4) NOT NULL Level

    Prompt Table: GM_SPNSR_LEVEL

    61 SPNSR_TYPE Character(4) VARCHAR2(4) NOT NULL Sponsor Type

    Prompt Table: GM_SPNSR_TYPE

    62 SPNSR_PROGRAM Character(4) VARCHAR2(4) NOT NULL Program Type

    Prompt Table: GM_SP_PROG_TYPE

    63 COST_LIV_INCR_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Cost of Living Increase Pct
    64 CFDA_NBR Number(6,3) DECIMAL(5,3) NOT NULL CFDA Number
    65 ALLOW_COPI Character(1) VARCHAR2(1) NOT NULL Allow CO-PI's

    Y/N Table Edit

    Default Value: N

    66 MULTI_PI Character(1) VARCHAR2(1) NOT NULL Allow Multiple PI's

    Y/N Table Edit

    Default Value: N

    67 FOREIGN_FLAG Character(1) VARCHAR2(1) NOT NULL Foreign

    Y/N Table Edit

    Default Value: N

    68 FED_SP_TYPE Character(4) VARCHAR2(4) NOT NULL Sponsor Type

    Prompt Table: GM_FED_SP_TYPE

    69 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
    B=Blocked
    C=Cleared
    R=Review
    V=Valid

    Default Value: V

    70 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: FSS_REASON_VW

    71 FSS_OFFSET_DAYS Number(5,0) INTEGER NOT NULL 02/20/06 EGS: Created
    72 GM_FEDERAL_FLAG Character(1) VARCHAR2(1) NOT NULL Federal

    Y/N Table Edit

    Default Value: N

    73 US_FLAG_CARRIER Character(1) VARCHAR2(1) NOT NULL US Flag Carrier Required

    Y/N Table Edit

    Default Value: N

    74 LOC_INDICATOR Character(1) VARCHAR2(1) NOT NULL Letter of Credit

    Y/N Table Edit

    Default Value: N

    75 GM_LOC_SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL Letter of Credit Sponsor

    Prompt Table: GM_LOC_SP_VW

    76 GGOV_FLG Character(1) VARCHAR2(1) NOT NULL GGOV_FLG

    Y/N Table Edit

    77 FA_SPNSR_BASE_ID Character(5) VARCHAR2(5) NOT NULL Sponsor Base

    Prompt Table: GM_FA_BASE_DTL

    78 GM_DEL_LOC_REFS_SW Character(1) VARCHAR2(1) NOT NULL Use this to "mark" parent records that need to have children records deleted.
    79 GRANTS_SPONSOR_FLG Character(1) VARCHAR2(1) NOT NULL Grants Management Sponsor
    N=No
    Y=Yes
    80 SPNSR_SALARY_CAP Signed Number(15,2) DECIMAL(13,2) NOT NULL SPNSR_SALARY_CAP
    81 FEDERAL_INDICATOR Character(1) VARCHAR2(1) NOT NULL Federal Vendor Information

    Y/N Table Edit

    Default Value: N

    82 TRADING_PARTNER Character(6) VARCHAR2(6) NOT NULL Trading Partner Code
    83 IPAC_INTERFACE Character(1) VARCHAR2(1) NOT NULL IPAC Interface

    Y/N Table Edit

    Default Value: N

    84 CNTCT_SEQ_IPAC Number(5,0) INTEGER NOT NULL Date Init. Issue # Description 10/09/01 JJM DI-EDWONG-17 Project Gemini enhancements 10/29/02 JJM F-C1ABANOS-25 Added IPAC label as default
    85 CUSTOMER_ALC Character(8) VARCHAR2(8) NOT NULL Customer Agency Location Code

    Prompt Table: AGENCY_LOC_CD

    86 CUSTOMER_DO Character(5) VARCHAR2(5) NOT NULL Disbursing office
    87 SYMBOL_REQ Character(1) VARCHAR2(1) NOT NULL Symbol flag required

    Y/N Table Edit

    Default Value: Y

    88 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
    CCR=CCR
    EBL=eBill Contact Maintenance
    FED=FED
    PEN=Pension Customer
    89 CUST_USF_STATUS Character(1) VARCHAR2(1) NOT NULL CCR Status of a Vendor
    A=Active
    E=Expired
    U=Unregistered
    X=Exempt

    Default Value: X

    90 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    91 FED_SHARE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Federal Share Percentage
    92 CONT_ALLOW_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Allowable Construction Pct
    93 CONT_NO_ALLW_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Not allowable Construction Pct
    94 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field
    95 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B
    96 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C
    97 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D
    98 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2
    99 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4
    100 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6
    101 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8
    102 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A
    103 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B
    104 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C
    105 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D
    106 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A
    107 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B
    108 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C
    109 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D
    110 CUST_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 A
    111 CUST_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 B
    112 CUST_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 C
    113 CUST_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 D
    114 CUST_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 A
    115 CUST_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 B
    116 CUST_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 C
    117 CUST_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 D
    118 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    119 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
    120 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    121 HOLD_UNPAID_BI Character(1) VARCHAR2(1) NOT NULL Hold Billing on Unpaid Cost

    Y/N Table Edit