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