|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
cp_acct_info |
Debit and credit account codes for each customer payments are maintained. |
ou_id |
int |
Organization Unit Id |
Yes |
No |
|
|
|
|
tran_no |
sql_variant |
Transaction Number |
|
|
|
|
|
|
fb_id |
|
Finance Book Id |
|
|
|
|
|
|
acc_code |
|
Account Code |
|
|
|
|
|
|
drcr_flag |
|
Debit Credit Flag |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
line_no |
int |
Line Number |
|
|
|
|
|
|
timestamp |
|
Time Stamp |
No |
|
|
|
|
|
tran_date |
datetime |
Transaction Date |
|
|
|
|
|
|
fin_post_date |
|
Finance Posting Date |
|
|
|
|
|
|
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 Currency Exchange Rate |
|
|
|
|
|
|
par_base_amt |
|
Parallel Base Amount |
|
|
|
|
|
|
status |
sql_variant |
Status. Values F - Fresh, RQ- Requested |
|
|
|
|
|
|
batch_id |
|
Batch Id |
|
|
|
|
|
|
company_code |
|
Company Code |
|
|
|
|
|
|
component_name |
|
Component Name |
|
|
|
|
|
|
acct_type |
|
Account Type |
|
|
|
|
|
|
bank_cash_code |
|
Bank Cash Code |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
cp_notes_dtl |
Table that contains the notes and comments details for the Document number |
ou_id |
sql_variant |
Organization Unit Id |
Yes |
|
|
|
|
|
voucher_no |
|
Voucher Number |
|
|
|
|
|
|
notes_for |
|
Notes For |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
note_level |
sql_variant |
Note Level |
|
|
|
|
|
|
std_notesid |
|
Standard Notes Id |
|
|
|
|
|
|
std_notesid_desc |
|
Standard Notes Id Description |
|
|
|
|
|
|
notes |
|
Notes |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
|
|
ref_doc_no |
sql_variant |
Reference Document Number |
|
|
|
|
cp_notes_tmp |
|
guid |
|
Guid |
Yes |
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
notes |
sql_variant |
Notes |
|
|
|
|
|
|
stdnotesid |
|
Standard Notes Id |
|
|
|
|
|
|
stdnotesiddesc |
|
Standard Notes Id Description |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
cp_tranno_tmp |
|
guid |
sql_variant |
Guid |
Yes |
|
|
|
|
|
tran_no |
|
Transaction Number |
|
|
|
|
|
|
lastmoddate |
datetime |
Last Modified |
No |
|
|
|
|
|
createdby |
sql_variant |
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
cp_voucher_hdr |
Maintains the customer payment’s that are raised agains the customer’s and the customer payment amounts. |
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
voucher_no |
sql_variant |
Voucher Number |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
pay_cat |
sql_variant |
Payment Category |
|
|
|
|
|
|
req_date |
datetime |
Request Date |
|
|
|
|
|
|
business_unit |
sql_variant |
Business Unit |
|
|
|
|
|
|
num_type |
|
Numbering Type |
|
|
|
|
|
|
cus_reg_at |
int |
Customer Register At |
|
|
|
|
|
|
cus_code |
sql_variant |
Customer Code |
|
|
|
|
|
|
pay_date |
datetime |
Payment Date |
|
|
|
|
|
|
pay_method |
sql_variant |
Payment Method |
|
|
|
|
|
|
pay_mode |
|
Pay Mode |
|
|
|
|
|
|
pay_route |
|
Pay Route |
|
|
|
|
|
|
pay_cur |
|
Pay Currency |
|
|
|
|
|
|
exch_rate |
bigint |
Exchange Rate |
|
|
|
|
|
|
pay_amount |
|
Pay Amount |
|
|
|
|
|
|
bank_cash_code |
sql_variant |
Bank Cash Code |
|
|
|
|
|
|
bank_charges |
|
Bank Charges |
|
|
|
|
|
|
doc_ref |
|
Document Reference |
|
|
|
|
|
|
priority |
|
Priority |
|
|
|
|
|
|
billing_pt |
int |
Billing Point |
|
|
|
|
|
|
relpay_pt |
|
Release Payment Point |
|
|
|
|
|
|
reason_code |
sql_variant |
Reason Code |
|
|
|
|
|
|
el_pay |
|
Electronic Payment |
|
|
|
|
|
|
elec_pay_applied |
|
Electronic Payment Applied |
|
|
|
|
|
|
remarks |
|
Remarks |
|
|
|
|
|
|
hldreason_code |
|
Hold Reason Code |
|
|
|
|
|
|
revreason_code |
|
Reversal Reason Code |
|
|
|
|
|
|
rev_date |
datetime |
Reversal Date |
|
|
|
|
|
|
esr_partid |
sql_variant |
ESR Part Id |
|
|
|
|
|
|
esr_ref |
|
ERS Reference |
|
|
|
|
|
|
esr_codingline |
|
ESR Coding Line |
|
|
|
|
|
|
lsv_contid |
|
LSV Contact Id |
|
|
|
|
|
|
lsv_ref |
|
LSV Reference |
|
|
|
|
|
|
cust_acct_in |
|
Customer Account Information |
|
|
|
|
|
|
cust_account |
|
Customer Account |
|
|
|
|
|
|
el_bank_pttcode |
|
Electronic Bank /PTT Code |
|
|
|
|
|
|
el_bank_id |
|
Electronic Bank Id |
|
|
|
|
|
|
cust_bank_acct |
|
Customer Bank Account |
|
|
|
|
|
|
status |
|
Status. Values F -Fresh, DL- Deleted, HL- Held, RQ-Requested, RT-Returned, RV-Reversed |
|
|
|
|
|
|
batch_id |
|
Batch Id |
|
|
|
|
|
|
pay_amt_bef_round |
bigint |
Payment Amount Before Round |
|
|
|
|
|
|
roundoff_amt |
|
Round Amount |
|
|
|
|
|
|
par_exchange_rate |
|
Parallel Exchange Rate |
|
|
|
|
|
|
hldrev_remarks |
sql_variant |
Hold Reversal Remarks |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|