Table C_BankStatementLoader
PRIMARY KEY
C_BankStatementLoader_ID
NUMBER (10, 0)
NOT NULL
AD_Client_ID
NUMBER (10, 0)
NOT NULL
AD_Org_ID
NUMBER (10, 0)
NOT NULL
IsActive
CHAR (1)
default: 'Y'
CHECK ( IsActive in ( 'Y' , 'N' ))
NOT NULL
Created
DATE
default: SYSDATE
NOT NULL
CreatedBy
NUMBER (10, 0)
NOT NULL
Updated
DATE
default: SYSDATE
NOT NULL
UpdatedBy
NUMBER (10, 0)
NOT NULL
Name
NVARCHAR2 (60)
NOT NULL
Description
NVARCHAR2 (255)
C_BankAccount_ID
NUMBER (10, 0)
NOT NULL
C_BankAccount
StmtLoaderClass
NVARCHAR2 (60)
FinancialInstitutionID
NVARCHAR2 (20)
BranchID
NVARCHAR2 (20)
UserID
NVARCHAR2 (60)
Password
NVARCHAR2 (60)
PIN
NVARCHAR2 (20)
AccountNo
NVARCHAR2 (20)
HostAddress
NVARCHAR2 (60)
HostPort
NUMBER (10, 0)
ProxyAddress
NVARCHAR2 (60)
ProxyPort
NUMBER (10, 0)
ProxyLogon
NVARCHAR2 (60)
ProxyPassword
NVARCHAR2 (60)
FileName
NVARCHAR2 (120)
DateLastRun
DATE
DateFormat
NVARCHAR2 (20)
FOREIGN KEY
CBankAcct_CBankStmtLoader: C_BankAccount_ID =>
C_BankAccount