|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
| dbo |
rr_acct_info_dtl |
Table that maintains the posting level info and Amounts for each Transaction numbers |
ou_id |
int |
Organization Unit Id |
Yes |
No |
|
|
|
tran_no |
sql_variant |
Transaction Number |
|
| |
|
|
|
tran_type |
|
Transaction Type |
|
| |
|
|
|
account_code |
|
Account Code |
|
| |
|
|
|
drcr_flag |
|
Debit Credit Flag |
|
| |
|
|
|
bank_code |
|
Bank Code |
|
| |
|
|
|
posting_line_no |
int |
Posting Line Number |
|
| |
|
|
|
timestamp |
|
Time Stamp |
No |
| |
|
|
|
fin_post_date |
datetime |
Finance Posted Date |
|
| |
|
|
|
currency_code |
sql_variant |
Currency Code |
|
| |
|
|
|
cost_center |
|
Cost Center |
|
| |
|
|
|
tran_amount |
bigint |
Transaction Amount |
|
| |
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
| |
|
|
|
analysis_code |
|
Analysis Code |
|
| |
|
|
|
subanalysis_code |
|
Subanalysis Code |
|
| |
|
|
|
basecur_erate |
bigint |
Base Currency Exchange Rate |
|
| |
|
|
|
base_amount |
|
Base Amount |
|
| |
|
|
|
pbcur_erate |
|
Parallel Base Currency Exchange Rate |
|
| |
|
|
|
par_base_amt |
|
Parallel Base Amount |
|
| |
|
|
|
fin_post_status |
sql_variant |
Finance Posting Status. Values P-Posted |
|
| |
|
|
|
guid |
|
Guid |
|
| |
|
|
|
company_code |
|
Company Code |
|
| |
|
|
|
account_type |
|
Account Type |
|
| |
|
|
|
bu_id |
|
Business Unit Id |
|
| |
|
|
|
ref_no |
|
Reference Number |
|
| |
|
|
|
dep_bank |
|
Depositing Bank |
|
| |
|
rr_acctlnk_tmp |
|
guid |
|
Guid |
Yes |
| |
|
|
|
payinslip_no |
|
Pay In Slip Number |
|
| |
|
|
|
bank_code |
|
Bank Code |
|
| |
|
rr_comp_tmp |
|
guid |
|
Guid |
|
| |
|
|
|
instr_no |
|
Instrument Number |
|
| |
|
|
|
remitting_bank |
|
Remitting Bank |
|
| |
|
|
|
receipt_no |
|
Receipt Number |
No |
| |
|
|
|
bank_code |
|
Bank Code |
|
| |
|
|
|
instr_date |
datetime |
Instrument Date |
|
| |
|
|
|
instr_amount |
bigint |
Instrument Amount |
|
| |
|
|
|
currency_code |
sql_variant |
Currency Code |
|
| |
|
|
|
remitter |
|
Remitter |
|
| |
|
|
|
collection_point |
int |
Collection Point |
|
| |
|
|
|
depositing_bank |
sql_variant |
Depositing Bank |
|
| |
|
|
|
payinslip_no |
|
Pay In Slip Number |
|
| |
|
|
|
payinslip_date |
datetime |
Pay In Slip Date |
|
| |
|
|
|
receipt_type |
sql_variant |
Receipt Type |
|
| |
|
|
|
receipt_status |
|
Receipt Status |
|
| |
|
|
|
dep_bank_changed |
|
Depositing Bank Changed |
|
| |
|
|
|
fb_id |
|
Finance Book Id |
|
| |
|
|
|
rec_bank_acctno |
|
Receipt Bank Account Number |
|
| |
|
|
|
dep_bank_acctno |
|
Deposit Bank Account Number |
|
| |
|
|
|
rec_bank_currency |
|
Receipt Bank Currency |
|
| |
|
|
|
dep_bank_currency |
|
Deposit Bank Currency |
|
| |
|
|
|
rec_base_exrate |
bigint |
Receipt Base Exchange Rate |
|
| |
|
|
|
rec_par_base_exrate |
|
Receipt Parallel Base Exchange Rate |
|
| |
|
|
|
dep_bank_fb_id |
sql_variant |
Deposit Bank Finance Book Id |
|
| |
|
|
|
dep_base_exrate |
bigint |
Deposit Base Exchange Rate |
|
| |
|
|
|
dep_par_base_exrate |
|
Deposit Parallel Base Exchange Rate |
|
| |
|
|
|
receipt_date |
datetime |
Receipt Date |
|
| |
|
|
|
buid |
sql_variant |
Business Unit Id |
|
| |
|
|
|
receiptdate |
datetime |
Receipt Date |
|
| |
|
RR_PAYINSLIP_DTL |
Table that contains the depositing bank details and instrumentation amounts against the created receipts. |
OU_ID |
decimal(4) |
Organization Unit Id |
Yes |
| |
|
|
|
PAYINSLIP_NO |
varchar(18) |
Pay In Slip |
|
| |
|
|
|
DEPOSITING_BANK |
varchar(32) |
Depositing Bank |
|
| |
|
|
|
INSTR_NO |
varchar(18) |
Instrument Number |
|
| |
|
|
|
REMITTING_BANK |
varchar(32) |
Remitting Bank |
|
| |
|
|
|
INSTR_DATE |
datetime |
Instrument Date |
No |
| |
|
|
|
INSTR_AMOUNT |
decimal(13,8) |
Instrument Amount |
|
| |
|
|
|
REMITTER |
varchar(60) |
Remitter |
|
| |
|
|
|
ADDRESS |
varchar(256) |
Address |
|
| |
|
|
|
RECEIPT_NO |
|
Receipt Number |
|
| |
|
|
|
CURRENCY |
varchar(5) |
Currency |
|
| |
|
|
|
RECEIPT_TYPE |
varchar(30) |
Receipt Type |
|
| |
|
|
|
PARENTKEY |
varchar(128) |
Parent Key |
|
| |
|
|
|
CURRENTKEY |
|
Current Key |
|
| |
|
|
|
COLLECTER_CODE |
varchar(15) |
Collection Code |
|
| |
|
|
|
INSTR_STATUS |
varchar(25) |
Instrument Status. Values BU -Bounced,DE- Deleted ,D -Deposited |
|
| |
|
|
|
REASON_CODE |
varchar(10) |
Reason Code |
|
| |
|
|
|
REMARKS |
varchar(256) |
Remarks |
|
| |
|
|
|
DEP_BANK_CHANGED |
varchar(12) |
Depositing Bank Changed |
|
| |
|
|
|
BANK_CODE |
varchar(32) |
Bank Code |
|
| |
|
|
|
AU_FB_ID |
varchar(20) |
Authorized Finance Book Id |
|
| |
|
|
|
BATCH_ID |
varchar(128) |
Batch Id |
|
| |
|
rr_payinslip_hdr |
Maintains the payinslip number and the depositing bank details. |
ou_id |
int |
Organization Unit Id |
Yes |
| |
|
|
|
payinslip_no |
sql_variant |
Pay In Slip Number |
|
| |
|
|
|
depositing_bank |
|
Depositing Bank |
|
| |
|
|
|
parentkey |
|
Parent Key |
|
| |
|
|
|
timestamp |
int |
Time Stamp |
No |
| |
|
|
|
payinslip_date |
datetime |
Pay In Slip Date |
|
| |
|
|
|
status |
sql_variant |
Status. Values F -Fresh, DE- Deleted, D-Deposited |
|
| |
|
|
|
fb_id |
|
Finance Book Id |
|
| |
|
|
|
createdby |
|
Created By |
|
| |
|
|
|
createddate |
datetime |
Created Date |
|
| |
|
|
|
modifiedby |
sql_variant |
Modified By |
|
| |
|
|
|
modifieddate |
datetime |
Modified Date |
|
| |
|
|
|
batch_id |
sql_variant |
Batch Id |
|
|