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 |