ACT table

Organizations

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

  1. ACT

Child tables

  1. OIO OBJECT INSTANCE REQUEST TARGET ORGANIZATION INFORMATION.
  2. ORC - Process Instance
  3. ORD - Orders
  4. AAD - Organizations-Groups, many-to-many link to USG table
  5. USR - Users
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License