OM_FED_CUST_AET(SQL Table) |
Index Back |
|---|---|
OM_FDRG_CUST state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |