|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
sr_acctinfo_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 |
|
|
|
|
|
|
acct_lineno |
int |
Accounting Line Number |
|
|
|
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
|
|
|
|
|
acc_code |
|
Account Code |
|
|
|
|
|
|
drcr_flag |
|
Debit Credit Flag |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
acct_type |
sql_variant |
Account Type |
|
|
|
|
|
|
fin_post_date |
datetime |
Finance Post Type |
|
|
|
|
|
|
currency |
sql_variant |
Currency |
|
|
|
|
|
|
cost_center |
|
Cost Center |
|
|
|
|
|
|
tran_amt |
bigint |
Transaction Amount |
|
|
|
|
|
|
business_unit |
sql_variant |
Business Unit |
|
|
|
|
|
|
analysis_code |
|
Analysis Code |
|
|
|
|
|
|
sub_analysis_code |
|
Subanalysis Code |
|
|
|
|
|
|
base_cur_exrate |
bigint |
Base Currency Exchange Rate |
|
|
|
|
|
|
base_amt |
|
Base Amount |
|
|
|
|
|
|
par_base_cur_exrate |
|
Parallel Base Current Exchange Rate |
|
|
|
|
|
|
par_base_amt |
|
Parallel Base Amount |
|
|
|
|
|
|
status |
sql_variant |
Status.Values FR-Fresh,AU-Authorized,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,TR-To be Reversed |
|
|
|
|
|
|
batch_id |
|
Batch Id |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
sr_notes_dtl |
Table that contains the notes and comments details for the Document number |
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
receipt_no |
sql_variant |
Receipt Number |
|
|
|
|
|
|
receipt_type |
|
Receipt Type |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
notes_for |
|
Notes For |
|
|
|
|
|
|
notes_level |
|
Notes Level |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
notes |
sql_variant |
Notes |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
sr_ot_acctinfo_tmp |
|
ou_id |
int |
Organization Unit Id |
|
|
|
|
|
|
receipt_no |
sql_variant |
Receipt Number |
|
|
|
|
|
|
guid |
|
Guid |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
sr_rcpt_tmp |
|
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
receipt_no |
sql_variant |
Receipt Number |
|
|
|
|
|
|
receipt_type |
|
Receipt Type |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
guid |
|
Guid |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
origin_no |
sql_variant |
Origin Number |
|
|
|
|
|
|
receipt_date |
datetime |
Receipt Date |
|
|
|
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
|
|
|
|
|
notype_no |
|
Numbering Type |
|
|
|
|
|
|
receipt_status |
|
Receipt Status.FR-Fresh,AU-Authorized,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,TR-To be Reversed |
|
|
|
|
|
|
supplier_code |
|
Supplier Code |
|
|
|
|
|
|
receipt_route |
|
Receipt Route |
|
|
|
|
|
|
receipt_method |
|
Receipt Method |
|
|
|
|
|
|
receipt_mode |
|
Receipt Mode |
|
|
|
|
|
|
bank_cash_code |
|
Bank Cash Code |
|
|
|
|
|
|
currency_code |
|
Currency Code |
|
|
|
|
|
|
exchange_rate |
bigint |
Exchange Rate |
|
|
|
|
|
|
receipt_amount_bef_roff |
|
Receipt Amount Before Round Off |
|
|
|
|
|
|
receipt_amount |
|
Receipt Amount |
|
|
|
|
|
|
apply |
sql_variant |
Apply |
|
|
|
|
|
|
remarks |
|
Remarks |
|
|
|
|
|
|
instr_no |
|
Instrument Number |
|
|
|
|
|
|
micr_no |
|
Micro Number |
|
|
|
|
|
|
instr_amount |
bigint |
Instrument Number |
|
|
|
|
|
|
instr_date |
datetime |
Instrument Date |
|
|
|
|
|
|
instr_status |
sql_variant |
Instrument Status.Values H-Realized,B-Bounced |
|
|
|
|
|
|
bank_code |
|
Bank Code |
|
|
|
|
|
|
charges |
bigint |
Charges |
|
|
|
|
|
|
ref_no |
sql_variant |
Reference Number |
|
|
|
|
|
|
cost_center |
|
Cost Center |
|
|
|
|
|
|
analysis_code |
|
Analysis Code |
|
|
|
|
|
|
sub_analysis_code |
|
Subanalysis Code |
|
|
|
|
|
|
reason_code |
|
Reason Code |
|
|
|
|
|
|
rr_flag |
|
Receipt Route Flag |
|
|
|
|
|
|
batch_id |
|
Batch Id |
|
|
|
|
|
|
pbcexchrate |
bigint |
Parallel Base Currency Exchange Rate |
|
|
|
|
|
|
createdby |
sql_variant |
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
sr_receipt_mst |
Mater table for supplier receipts. |
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
receipt_no |
sql_variant |
Receipt Number |
|
|
|
|
|
|
receipt_type |
|
Receipt Type |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
origin_no |
sql_variant |
Origin Number |
|
|
|
|
|
|
receipt_date |
datetime |
Receipt Date |
|
|
|
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
|
|
|
|
|
notype_no |
|
Numbering Type |
|
|
|
|
|
|
receipt_status |
|
Receipt Status.Values FR-Fresh,AU-Authorized,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,TR-To be Reversed |
|
|
|
|
|
|
supplier_code |
|
Supplier Code |
|
|
|
|
|
|
receipt_route |
|
Receipt Route |
|
|
|
|
|
|
receipt_method |
|
Receipt Method |
|
|
|
|
|
|
receipt_mode |
|
Receipt Mode |
|
|
|
|
|
|
bank_cash_code |
|
Bank Cash Code |
|
|
|
|
|
|
currency_code |
|
Currency Code |
|
|
|
|
|
|
exchange_rate |
bigint |
Exchange Rate |
|
|
|
|
|
|
receipt_amount_bef_roff |
|
Receipt Amount Before Round Off |
|
|
|
|
|
|
receipt_amount |
|
Receipt Amount |
|
|
|
|
|
|
apply |
sql_variant |
Apply |
|
|
|
|
|
|
remarks |
|
Remarks |
|
|
|
|
|
|
instr_no |
|
Instrument Number |
|
|
|
|
|
|
micr_no |
|
Micro Number |
|
|
|
|
|
|
instr_amount |
bigint |
Instrument Amount |
|
|
|
|
|
|
instr_date |
datetime |
Instrument Date |
|
|
|
|
|
|
instr_status |
sql_variant |
Instrument Status.Values H-Realized,B-Bounced |
|
|
|
|
|
|
bank_code |
|
Bank Code |
|
|
|
|
|
|
charges |
bigint |
Charges |
|
|
|
|
|
|
ref_no |
sql_variant |
Reference Number |
|
|
|
|
|
|
cost_center |
|
Cost Center |
|
|
|
|
|
|
analysis_code |
|
Analysis Code |
|
|
|
|
|
|
sub_analysis_code |
|
Subanalysis Code |
|
|
|
|
|
|
reason_code |
|
Reason Code |
|
|
|
|
|
|
rr_flag |
|
Receipt Route Flag |
|
|
|
|
|
|
batch_id |
|
Batch Id |
|
|
|
|
|
|
pbcexchrate |
bigint |
Parallel Base Currency Exchange Rate |
|
|
|
|
|
|
createdby |
sql_variant |
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
SR_Receipt_tmp |
|
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
receipt_no |
sql_variant |
Receipt Number |
|
|
|
|
|
|
receipt_type |
|
Receipt Type |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
origin_no |
sql_variant |
Origin Number |
|
|
|
|
|
|
receipt_date |
datetime |
Receipt Date |
|
|
|
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
|
|
|
|
|
notype_no |
|
Numbering Type |
|
|
|
|
|
|
receipt_status |
|
Receipt Status.Values FR-Fresh,AU-Authorized,RT-Returned,RV-Reversed,DT-Deleted,HD-Held,TR-To be Reversed |
|
|
|
|
|
|
supplier_code |
|
Supplier Code |
|
|
|
|
|
|
receipt_route |
|
Receipt Route |
|
|
|
|
|
|
receipt_method |
|
Receipt Method |
|
|
|
|
|
|
receipt_mode |
|
Receipt Mode |
|
|
|
|
|
|
bank_cash_code |
|
Bank Cash Code |
|
|
|
|
|
|
currency_code |
|
Currency Code |
|
|
|
|
|
|
exchange_rate |
bigint |
Exchange Rate |
|
|
|
|
|
|
receipt_amount_bef_roff |
|
Receipt Amount Before Round Off |
|
|
|
|
|
|
receipt_amount |
|
Receipt Amount |
|
|
|
|
|
|
apply |
sql_variant |
Apply |
|
|
|
|
|
|
remarks |
|
Remarks |
|
|
|
|
|
|
instr_no |
|
Instruction Number |
|
|
|
|
|
|
micr_no |
|
MICR Number |
|
|
|
|
|
|
instr_amount |
bigint |
Instrument Amount |
|
|
|
|
|
|
instr_date |
datetime |
Instrument Date |
|
|
|
|
|
|
instr_status |
sql_variant |
Instrument Status.Values H-Realized,B-Bounced |
|
|
|
|
|
|
bank_code |
|
Bank Code |
|
|
|
|
|
|
charges |
bigint |
Charges |
|
|
|
|
|
|
ref_no |
sql_variant |
Reference Number |
|
|
|
|
|
|
cost_center |
|
Cost Center |
|
|
|
|
|
|
analysis_code |
|
Analysis Code |
|
|
|
|
|
|
sub_analysis_code |
|
Subanalysis Code |
|
|
|
|
|
|
reason_code |
|
Reason Code |
|
|
|
|
|
|
rr_flag |
|
Receipt Route Flag |
|
|
|
|
|
|
batch_id |
|
Batch Id |
|
|
|
|
|
|
pbcexchrate |
bigint |
Parallel Base Currency Exchange Rate |
|
|
|
|
|
|
createdby |
sql_variant |
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|