-- DD_AUDIT  Direct Deposit Audit Table                     

--**Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences. The scripts and information are provided "as is" without warranty, implied or otherwise. Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:) 

CREATE TABLE DD_AUDIT
(DD_AUDIT_SOURCE             VARCHAR2(1),
 DD_AUDIT_VEND_CHECK_PIDM    NUMBER(8),
 DD_AUDIT_CHECK_NUM          VARCHAR2(8),
 DD_AUDIT_INVH_CODE          VARCHAR2(8),
 DD_AUDIT_CHECK_DATE         DATE,
 DD_AUDIT_NET_AMT            NUMBER(12,2),
 DD_AUDIT_ATYP_CODE_VEND     VARCHAR2(2),
 DD_AUDIT_ATYP_SEQ_NUM_VEND  NUMBER(2),
 DD_AUDIT_BANK_ROUT_NUM      VARCHAR2(9),
 DD_AUDIT_BANK_ACCT_NUM      VARCHAR2(17),
 DD_AUDIT_ACCT_TYPE          VARCHAR2(1),
 DD_AUDIT_PAYMT_TYPE_IND     VARCHAR2(1),
 DD_AUDIT_ACTIVITY_DATE      DATE);