OM_FED_CUST_AET

(SQL Table)
Index Back

OM_FDRG_CUST state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OM_FLAG Character(1) VARCHAR2(1) NOT NULL OM Work Flag
3 CURRENT_DATE1 Date(10) DATE 12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label
4 CURRENT_DTTM DateTime(26) TIMESTAMP 08/27/01 EGS (CN#PL900-1.0): Added
5 AR_IPAC Character(1) VARCHAR2(1) NOT NULL AR IPAC Interface
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 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.
8 TOTAL_AGED_AR Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Aged AR
9 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
A=Active
I=Inactive
T=Template
10 CUST_STATUS_DT Date(10) DATE Customer Status Date
11 EXP_PENDING Character(1) VARCHAR2(1) NOT NULL Expiration pending flag
12 CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No indicator
13 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
14 ALT_NAME2 Character(40) VARCHAR2(40) NOT NULL Alternate Name 2
15 FULLNAME Character(60) VARCHAR2(60) NOT NULL Full name
16 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
17 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
18 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
19 LEGAL_BUS_NAME Character(120) VARCHAR2(120) NOT NULL Legal Business Name
20 FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag1
21 FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag2
22 FLAG3 Character(1) VARCHAR2(1) NOT NULL Flag3
23 FLAG4 Character(1) VARCHAR2(1) NOT NULL Flag4
24 FLAG5 Character(1) VARCHAR2(1) NOT NULL Flag5
25 FLAG6 Character(1) VARCHAR2(1) NOT NULL Flag 6