Customer Balance Transfer

dbo

ctrn_acct_info

Stores accounting information

ou_id

int

Organization Unit Id

Yes

No

tran_type

nvarchar(40)

Transaction Type

tran_no

nvarchar(18)

Transaction Number

transfer_doc_no

Transfer Document Number

acc_code

nvarchar(32)

Account Code

drcr_flag

nvarchar(6)

Debit Credit Flag

acc_type

nvarchar(40)

Account Type

timestamp

int

Time Stamp

No

fb_id

nvarchar(20)

Finance Book Id

fin_post_date

datetime

Finance Posted  Date

currency

nvarchar(5)

Currency

customer_code

nvarchar(18)

Customer Code

cost_center

nvarchar(10)

Cost Center

tran_amt

bigint

Transaction Amount

analysis_code

nvarchar(5)

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

nvarchar(25)

Status. Values P-Posted

batch_id

nvarchar(40)

Batch Id

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_attach_notes

Stores Information about the Notes that get attached in the system

voucher_no

nvarchar(18)

Voucher Number

ref_doc_no

Reference Document Number

ref_doc_ou

int

Reference Document Organization Unit

std_notes_id

nvarchar(18)

Standard Notes Id

std_notes_desc

nvarchar(100)

Standard Notes Description

paybatch_no

nvarchar(18)

Pay Batch Number

notes

nvarchar(2000)

Notes

notes_level

nvarchar(10)

Notes Level

notes_for

nvarchar(30)

Notes For

vouch_ouid

int

Voucher Organization Unit Id

ctrn_ci_transfer_tmp

ou_id

Organization Unit Id

transfer_doc_no

nvarchar(18)

Transfer Document Number

timestamp

int

Time Stamp

tran_date

datetime

Transaction Date

tran_bal_in

nvarchar(15)

Transaction Balance Information

transferor

nvarchar(18)

Transferor

transferor_fb

nvarchar(20)

Transferor Finance Book

transferee_fb

Transferee Finance Book

transferor_currency

nvarchar(5)

Transferor Currency

transferee_currency

Transferee Currency

auto_adjust

nvarchar(10)

Automatic Adjust

transferee

nvarchar(18)

Transferee

transferor_docno

Transferor Document Number

transferor_doctype

nvarchar(40)

Transferor Document Type

transferee_docno

nvarchar(18)

Transferee Document Number

transferee_doctype

nvarchar(40)

Transferee Document Type

status

nvarchar(25)

Status

trasfer_type

Transfer Type

trasferee_acc_code

nvarchar(32)

Transferee Account Code

trasfer_acc_code

Transfer Account Code

accbalance

bigint

Account Balance

batch_id

nvarchar(40)

Batch Id

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_comptot_tmp

timestamp

int

Time Stamp

guid

nvarchar(40)

Guid

total_amt

bigint

Total Amount

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_credit_note_dtl

Stores Information about the Credit notes

ou_id

int

Organization Unit Id

Yes

tcn_no

nvarchar(18)

Transaction Number

timestamp

int

Time Stamp

No

transfer_doc_no

nvarchar(18)

Transfer Document Number

tran_date

datetime

Transaction Date

customer_code

nvarchar(18)

Customer Code

currency_code

nvarchar(5)

Currency Code

account_code

nvarchar(32)

Account Code

bu_id

nvarchar(20)

Business Unit Id

tran_amount

bigint

Transaction Amount

cost_center

nvarchar(10)

Cost Center

analysis_code

nvarchar(5)

Analysis Code

subanalysis_code

Subanalysis Code

exchange_rate

bigint

Exchange Rate

par_exchange_rate

Parallel Exchange Rate

transferee_amt

Transferee Amount

reason_code

nvarchar(10)

Reason Code

comments

nvarchar(256)

Comments

ref_doc_no

nvarchar(18)

Reference Document Number

status

nvarchar(25)

Status. Values P-Posted

batch_id

nvarchar(40)

Batch Id

tran_type

Transaction Type

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_debit_note_dtl

Stores Information about the Debit notes

ou_id

int

Organization Unit Id

Yes

tdn_no

nvarchar(18)

Number

timestamp

int

Time Stamp

No

transfer_doc_no

nvarchar(18)

Transfer Document Number

tran_date

datetime

Transaction Date

customer_code

nvarchar(18)

Customer Code

currency_code

nvarchar(5)

Currency Code

account_code

nvarchar(32)

Account Code

bu_id

nvarchar(20)

Business Unit Id

tran_amount

bigint

Transaction Amount

cost_center

nvarchar(10)

Cost Center

analysis_code

nvarchar(5)

Analysis Code

par_exchange_rate

bigint

Parallel Exchange Rate

subanalysis_code

nvarchar(5)

Subanalysis Code

exchange_rate

bigint

Exchange Rate

transferee_amt

Transferee Amount

reason_code

nvarchar(10)

Reason Code

comments

nvarchar(256)

Comments

ref_doc_no

nvarchar(18)

Reference Document Number

status

nvarchar(25)

Status. Values P-Posted

batch_id

nvarchar(40)

Batch Id

tran_type

Transaction Type

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_doc_dtl

Stores Information about all the documents

doc_no

nvarchar(18)

Document Number

Yes

guid

nvarchar(40)

Guid

ou_id

int

Organization Unit Id

tcn_no

nvarchar(18)

Number

timestamp

int

Time Stamp

No

doc_type

nvarchar(40)

Document Type

doc_date

datetime

Document Date

cust_area

int

Customer Area

doc_amt

bigint

Document Amount

doc_status

nvarchar(25)

Document Status. Values F -Fresh, D -Draft, A -Authorised

transfer_status

Transfer Status. Values F -Fresh, D -Draft, A -Authorised

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_doc_dtl_tmp

timestamp

int

Time Stamp

ou_id

Organization Unit Id

tcn_no

nvarchar(18)

Number

doc_no

Document Number

guid

nvarchar(40)

Guid

doc_type

Document Type

doc_date

datetime

Document Status

cust_area

int

Customer Area

doc_amt

bigint

Document Amount

doc_status

nvarchar(25)

Document Status

transfer_status

Transfer Status

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_pay_dtl

Stores Information about all the payments

ou_id

int

Organization Unit Id

Yes

tdn_no

nvarchar(18)

Number

term_no

nvarchar(15)

Term Number

pay_term

Pay Term

flag

nvarchar(25)

Flag

timestamp

int

Time Stamp

No

due_date

datetime

Due Date

due_amt_type

nvarchar(15)

Due Amount

due_per

bigint

Due Percentage

due_amt

Due Amount

dis_type

nvarchar(30)

Discount Type

dis_comp_amt

bigint

Discount Computed Amount

dis_date

datetime

Discount Date

dis_per

bigint

Discount Per

dis_amt

Discount Amount

penalty_per

Penalty Percentage

esr_ref_no

nvarchar(27)

ESR Reference Number

esr_line

nvarchar(128)

ESR Line

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_pay_dtl_tmp

ou_id

int

Organization Unit Id

Yes

tdn_no

nvarchar(18)

Number

term_no

nvarchar(15)

Term Number

guid

nvarchar(40)

Guid

pay_term

nvarchar(15)

Pay Term

flag

nvarchar(25)

Flag

timestamp

int

Time Stamp

No

due_date

datetime

Due Date

due_amt_type

nvarchar(15)

Due Amount Type

due_per

bigint

Due Percentage

due_amt

Due Amount

dis_type

nvarchar(30)

Discount Type

dis_comp_amt

bigint

Discount Computed Amount

dis_date

datetime

Discount Date

dis_per

bigint

Discount Per

dis_amt

Discount Amount

penalty_per

Penalty Percentage

esr_ref_no

nvarchar(18)

ESR Reference Number

esr_line

nvarchar(40)

ESR Line

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_pay_hdr

Stores Information about all the payments

ou_id

int

Organization Unit Id

Yes

tdn_no

nvarchar(18)

Number

flag

nvarchar(25)

Flag

pay_term

nvarchar(15)

Pay Term

timestamp

int

Time Stamp

No

disc_type

nvarchar(30)

Discount Type

rpt_method

nvarchar(25)

Report Method

esr_bank_code

nvarchar(32)

ESR Bank Code

esr_id

ESR Id

lsv_bank_code

LSV Bank Code

lsv_id

LSV Id

lsv_ref

nvarchar(18)

LSV Reference

cust_bank_acc

nvarchar(32)

Customer Bank Account

cust_bank_id

Customer Bank Id

acc_in

nvarchar(15)

Account Information

ptt_ref

nvarchar(18)

PTT Reference

ptt_acc_no

nvarchar(32)

PTT Account Number

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_tranno_tmp

guid

nvarchar(40)

Guid

Yes

tran_no

nvarchar(18)

Transaction Number

timestamp

int

Time Stamp

No

tran_type

nvarchar(40)

Transaction Type

createdby

nvarchar(15)

Created By

newguid

nvarchar(40)

New Guid

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date

ctrn_transfer_bal_hdr

Stores Information about all the balances

ou_id

int

Organization Unit Id

Yes

transfer_doc_no

nvarchar(18)

Transfer Document Number

timestamp

int

Time Stamp

No

tran_date

datetime

Transaction Date

tran_bal_in

nvarchar(15)

Transaction Balance Information

transferor

nvarchar(18)

Transferor

auto_adjust

nvarchar(10)

Automatic  Adjustment

transferee

nvarchar(18)

Transferee

transferor_docno

Transferor Document Number

transferor_doctype

nvarchar(40)

Transferor Document Type

transferee_docno

nvarchar(18)

Transferee Document Number

transferee_doctype

nvarchar(40)

Transferee Document Type

status

nvarchar(25)

Status. Values F -Fresh, D -Draft, A -Authorised

batch_id

nvarchar(40)

Batch Id

trasferee_acc_code

nvarchar(32)

Transferee Account Code

trasfer_acc_code

Transfer Account Code

accbalance

bigint

Account Balance

createdby

nvarchar(15)

Created By

createddate

datetime

Created Date

modifiedby

nvarchar(15)

Modified By

modifieddate

datetime

Modified Date