ACT table
Fields
| ACT_KEY | NUMBER(19) | not null |
| ACT_CUST_TYPE | VARCHAR2(50) | |
| ACT_STATUS | VARCHAR2(50) | |
| ACT_CUST_ACCT_NO | VARCHAR2(25) | |
| ACT_CARRIER_CODE_1 | VARCHAR2(20) | |
| ACT_CARRIER_CODE_2 | VARCHAR2(20) | |
| ACT_CARRIER_CODE_3 | VARCHAR2(20) | |
| ACT_BILL_ID | VARCHAR2(8) | |
| ACT_SIC | VARCHAR2(18) | |
| ACT_BIZRES | VARCHAR2(1) | |
| ACT_OWNERSHIP | VARCHAR2(18) | |
| ACT_RESPORG_CODE | VARCHAR2(5) | |
| ACT_SALES_CITY | VARCHAR2(3) | |
| ACT_CUST_CODE_1 | VARCHAR2(20) | |
| ACT_CUST_CODE_2 | VARCHAR2(20) | |
| ACT_CUST_CODE_3 | VARCHAR2(20) | |
| ACT_NAME | VARCHAR2(256) | not null |
| ACT_DIVISION | VARCHAR2(30) | |
| ACT_BIZ_GROUP | VARCHAR2(30) | |
| ACT_LOA_DATE | DATE | |
| ACT_FED_TAX_ID | VARCHAR2(10) | |
| ACT_FIN_CNTRACT_ID | VARCHAR2(10) | |
| ACT_CONTRACT_ID | VARCHAR2(10) | |
| ACT_RANGEP | VARCHAR2(3) | |
| ACT_CIC_CODE | VARCHAR2(4) | |
| ACT_PIC_FEE_WAIVER | VARCHAR2(1) | |
| ACT_HIERARCHY | VARCHAR2(4) | |
| ACT_SALES_CHANNEL | VARCHAR2(2) | |
| ACT_DISABLED | VARCHAR2(1) | |
| PARENT_KEY | NUMBER(19) | |
| ACT_UPDATE_AD | VARCHAR2(20) | |
| ACT_LDAP_PATH | VARCHAR2(100) | |
| ACT_MAX_USERS | NUMBER(10) | |
| ACT_UPN | VARCHAR2(256 CHAR) | |
| ACT_BILLING_SYS_KEY VARCHAR2(15) | ||
| BILLING_SYS_NAME | VARCHAR2(100) | |
| ACT_DISABLED_BY_PARENT VARCHAR2(1) | ||
| ACT_DATA_LEVEL | NUMBER(1) | |
| ACT_CREATE | DATE | |
| ACT_CREATEBY | NUMBER(19) | |
| ACT_UPDATE | DATE | |
| ACT_UPDATEBY | NUMBER(19) | |
| ACT_NOTE | CLOB | |
| ACT_ROWVER | RAW(8) |
Parent tables
Child tables
page revision: 3, last edited: 11 Aug 2011 08:06
