Iam having table
describe sop_deal_xref
Name Null Type
------------------------------ -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DIST_NUMBER NOT NULL VARCHAR2(10)
DIST_BRANCH VARCHAR2(3)
DAYS_PRICE_PROT NOT NULL NUMBER(11)
TAPE_DAYS_PRICE_PROT NOT NULL NUMBER(11)
DAYS_IN_TRANSIT NOT NULL NUMBER(11)
ACTIVE_IND CHAR(1)
COMM_IND CHAR(1)
SHORT_NAME VARCHAR2(50)
SG_BILL_TO_CUST_NO VARCHAR2(10)
TAPE_BILL_TO_CUST_NO VARCHAR2(10)
SG_SHIP_TO_CUST_NO VARCHAR2(10)
TAPE_SHIP_TO_CUST_NO VARCHAR2(10)
NAME_FLAG CHAR(1)
ADMIN_GLOBAL_ID VARCHAR2(12)
ZIP_CODE_PREFIX VARCHAR2(3)
DAILY_POS CHAR(1)
PRIMARY_SALES_OUT CHAR(1)
PRIMARY_COUNTRY_FLAG CHAR(1)
PRIMARY_START_DATE DATE
CWAC_ID VARCHAR2(6)
COMMENT_ID NOT NULL NUMBER(11)
LAST_UPD_BY VARCHAR2(40)
LAST_UPD_DATE DATE
DESIGN_IN_IND CHAR(1)
CLAIM_PROCESSOR VARCHAR2(12)
PRE_APPROVER_ID VARCHAR2(12)
CLAIMS_WITHIN_DAYS NOT NULL NUMBER(11)
SG_AREA_CODE VARCHAR2(10)
CLAIM_TYPE NOT NULL VARCHAR2(12)
ART_APPROVER_ID VARCHAR2(12)
ACCT_PAY_ID VARCHAR2(20)
TAPE_ACCT_PAY_ID VARCHAR2(20)
POS_CORP_CODE VARCHAR2(10)
POS_CUST_NAME VARCHAR2(35)
POS_COUNTRY VARCHAR2(20)
POS_STREET_ADDR VARCHAR2(255)
POS_CITY VARCHAR2(23)
POS_STATE VARCHAR2(30)
POS_ZIP VARCHAR2(10)
INDIRECT_DISTI CHAR(1)
ARCHIVE_DATE DATE
CONT_CUST_EFFDATE DATE
LSID NOT NULL NUMBER(11)
POS_COUNTRY_CODE VARCHAR2(2)
SEGMENTATION VARCHAR2(50)
POS_STREET_ADDR2 VARCHAR2(255)
INVENTORY_AUDIT_DATE DATE
PROCESS_REGION VARCHAR2(2)
CATEGORY_TYPE VARCHAR2(20)
OVERRIDE_ZIPCODE VARCHAR2(10)
OVERRIDE_COUNTRYCODE VARCHAR2(2)
OVERRIDE_COM_FLAG VARCHAR2(1)
POS_STREET_ADDR3 VARCHAR2(30)
POS_STREET_ADDR4 VARCHAR2(30)
POS_STREET_ADDR5 VARCHAR2(30)
POS_STREET_ADDR6 VARCHAR2(30)
POS_STATE_CODE VARCHAR2(2)
DIST_NUMBER_CE VARCHAR2(10)
SG_BILL_TO_CUST_NO_CE VARCHAR2(10)
DIST_NUMBER_RTL VARCHAR2(10)
SG_BILL_TO_CUST_NO_RTL VARCHAR2(10)
DIST_NUMBER_MXO VARCHAR2(10)
SG_BILL_TO_CUST_NO_MXO VARCHAR2(10)
SRP_CATEGORY VARCHAR2(15)
PTPP_DIST_NUMBER VARCHAR2(10)
BOOKED_REVENUE VARCHAR2(32)
GROUP_DIST_NUMBER_ZYME VARCHAR2(10)
ZYME_CUTOVER_DATA_DATE DATE
DIST_TIMEZONE VARCHAR2(20)
CURRENCY_CODE VARCHAR2(15)
i would need to create a audit trail table for sop_deal_xref and need to add in the additional two columns
1. Action being done time
2. User id capture for Data Base
It has few places where those tables could be touched upon, either through web application, scheduled job or manual transaction
Edited by: user9093700 on Mar 6, 2012 4:38 PM