Credit Management

Table Name cm_accountinfo_dtl

Table Comment Stores Credit Management Accounting Informations

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
account_code	sql_variant	Account Code
crdr_flag		Credit Debit Flag
currency		Currency
tran_amt	bigint	Transaction Amount
fb_id	sql_variant	Finance Book Id
costcenter_code		Cost Center Code
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
base_erate	bigint	Base Exchange Rate
base_amt		Base Amount
pbc_erate		Parallel Base Currency Exchange Rate
pbase_amt		Parallel Base Amount
tran_type	sql_variant	Transaction Type
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
sequence_no	int	Sequence Number

Table Name cm_accountinfo_hdr

Table Comment Stores Credit Management Accounting informations

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
timestamp	int	Time Stamp	No
tran_type	sql_variant	Transaction Type
tran_date	datetime	Transaction Date
post_date		Posted Date
ref_tranno	sql_variant	Reference Transaction Number
type_flag		Type Flag
resou_id	int	Resource Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number

Table Name cm_baddebt_dtl

Table Comment Stores Information about the bad debts

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
type_flag		Type Flag
sequence_no	int	Sequence Numner
timestamp		Time Stamp	No
doc_type	sql_variant	Document Type
doc_no		Document Number
currency		Currency
cust_code		Customer Code
cust_area	int	Customer Area
billing_point	sql_variant	Billing Point
due_no		Due Number
due_date	datetime	Due Date
due_amt	bigint	Due Amount
overdue_days	int	Over Due Days
overdue_amt	bigint	Over Due Amount
exchange_rate		Exchange Rate
pbc_erate		Parallel Base Currency Exchange Rate
provision_amt		Provision Amount
existprov_amt		Exist provison Amount
reversal_amt		Reversal Amount
writeoff_amt		Write Off Amount
writeback_amt		Write Back Amount
receipt_ou	int	Receipt Organization Unit
receipt_no	sql_variant	Receipt Number
remarks		Remarks
base_amt	bigint	Base Amount
crdrnote_no	sql_variant	Credit Note Number
doc_tran_type		Document Transaction Type
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
type_flag		Type Flag
sequence_no	int	Sequence Numner

Table Name cm_baddebt_hdr

Table Comment Stores Information about the bad debts

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
type_flag		Type Flag
timestamp	int	Time Stamp	No
tran_date	datetime	Transaction Date
fb_id	sql_variant	Finacne Book Id
costcenter_code		Cost Center Code
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
total_base_amt	bigint	Total Base Amount
total_pbc_amt		Total Parallel Base Amount
currency_code	sql_variant	Currency Code
resou_id	int	Resource Id
tran_type	sql_variant	Transaction Type
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
tran_no		Transaction Number
type_flag		Type Flag

Table Name cm_ci_custupdate_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
request_no		Request Number
type_flag		Type Flag
timestamp	int	Time Stamp	No
action	sql_variant	Action
voucher_no		Voucher Number
createdby		Created  By
createddate	datetime	Created  Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
request_no		Request Number
type_flag		Type Flag

Table Name cm_ci_woffupdate_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
doc_type	sql_variant	Document Type
doc_no		Document Number
cust_code		Customer Code
currency		Currency
exchange_rate	bigint	Exchange Rate
base_amt		Base Amount
billing_point	sql_variant	Billing Point
fb_id		Finance Book Id
tran_ou	int	Transaction Organization Unit
term_no	sql_variant	Term Number
tran_type		Transaction Type
writeoff_amt	bigint	Write Off Amount
tran_date	datetime	Transaction Date
pbc_erate	bigint	Parallel Base Currency Exchange Rate
pbc_amount		Parallel Base Currency Amount
company_code	sql_variant	Company Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_crdr_note_accinfo_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
accseq_no		Account Sequence Number
timestamp		Time Stamp	No
account_code	sql_variant	Account Code
crdr_flag		Credit Debit Flag
currency		Currency
tran_amt	bigint	Transaction Amount
fb_id	sql_variant	Finance Book Id
costcenter_code		Cost Center Code
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
base_erate	bigint	Base Exchange Rate
base_amt		Base Amount
pbc_erate		Parallel Base Currency Exchange Rate
pbase_amt		Parallel Base Amount
tran_type	sql_variant	Transaction Type
tran_no		Transaction Number
tran_date	datetime	Transaction Date
posting_date		Posting Date
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
accseq_no		Account Sequence Number

Table Name cm_crdr_note_custinfo_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
cust_code	sql_variant	Customer Code
currency		Currency
fb_id		Finance Book Id
tran_amt	bigint	Transaction Amount
exchange_rate		Exchange Rate
base_amt		Base Amount
tran_ou	int	Transaction Organization Unit
tran_type	sql_variant	Transaction Type
pbc_erate	bigint	Parallel Base Currency Exchange Rate
pbase_amt		Parallel Base Amount
crdr_note_flag	sql_variant	Credit Debit Note Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_creditcheck_dtl

Table Comment Stores Information about the credit checks

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
companybu_code	sql_variant	Company  Business Unit Code	Yes	No
type_flag		Type Flag
sequence_no	int	Sequence Number
effective_from	datetime	Effective From
bucketno	int	Bucket Number
timestamp		Time Stamp	No
daysfrom		Days From
daysto		Days To
status	sql_variant	Status.Values A -Active,I -Inactive
weightage	bigint	Weightage
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
companybu_code	sql_variant	Company  Business Unit Code	Yes	No
type_flag		Type Flag
sequence_no	int	Sequence Number
effective_from	datetime	Effective From
bucketno	int	Bucket Number

Table Name cm_creditcheck_hdr

Table Comment Stores Information about the credit checks

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
companybu_code	sql_variant	Company Business Unit Code	Yes	No
type_flag		Type Flag
sequence_no	int	Sequence Number
effective_from	datetime	Effective From
timestamp	int	Time Stamp	No
effective_to	datetime	Effective To
holdfor_order	bigint	Hold For Order
holdfor_pick		Hold For Pickup
holdfor_ship		Hold For Ship
frequency	sql_variant	Frequency
balance_type		Balance Type
credit_check_type		Credit Check Type
start_date	datetime	Start Date
resou_id	int	Resource Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
companybu_code	sql_variant	Company Business Unit Code	Yes	No
type_flag		Type Flag
sequence_no	int	Sequence Number
effective_from	datetime	Effective From

Table Name cm_creditrating_his

Table Comment Stores History Information about the credit ratings

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
actiontime	datetime	Action Time
timestamp	int	Time Stamp	No
credit_checkdate	datetime	Credit Check Date
credit_rating	bigint	Credit Rating
order_status	sql_variant	Order Status
pick_status		Pickup Status
ship_status		Ship Status
credit_checklvl		Credit Check Level
run_date	datetime	Run Date
run_no	int	Run Number
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
actiontime	datetime	Action Time

Table Name cm_creditrating_mst

Table Comment Stores Information about the credit ratings

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
timestamp	int	Time Stamp	No
credit_checkdate	datetime	Credit Check Date
credit_rating	bigint	Credit Rating
order_status	sql_variant	Order Status.Values OR -Ordering
pick_status		Pickup Status.Values PK -Picking
ship_status		Ship Status.Values SH -Shipping
credit_checklvl		Credit Check Level
run_date	datetime	Run Date
run_no	int	Run Number
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code

Table Name cm_creditstatus_his

Table Comment Stores History Information about the credit status

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
status_type		Status Type.Values SH -Shipping,PK -Picking,OR -Ordering
action_time	datetime	Action Time
timestamp	int	Time Stamp	No
status	sql_variant	Status.Values A -Active,I -Inactive
reason_code		Reason Code
effective_from	datetime	Effective From
effective_to		Effective To
remarks	sql_variant	Remarks
modified_by		Modified By
modified_date	datetime	Modified Date
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
status_type		Status Type.Values SH -Shipping,PK -Picking,OR -Ordering
action_time	datetime	Action Time

Table Name cm_creditstatus_mst

Table Comment Stores Information about the credit status

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
status_type		Status Type.Values SH -Shipping,PK -Picking,OR -Ordering
timestamp	int	Time Stamp	No
modified_date	datetime	Modiied Date
status	sql_variant	Status.Values A -Active,I -Inactive
reason_code		Reason Code
effective_from	datetime	Effective From
effective_to		Effective To
remarks	sql_variant	Remarks
modified_by		Modified By
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
doc_status	sql_variant	Document Status.Values A -Active,I -Inactive

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
bu_id		Business Unit Id
cust_code		Customer Code
status_type		Status Type.Values SH -Shipping,PK -Picking,OR -Ordering

Table Name cm_creditterm_dtl

Table Comment Stores Information about the credit terms

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
companybu_code	sql_variant	Company Business Unit  Code	Yes	No
type_flag		Type Flag
creditterm_code		Credit Term Code
bucketno	int	Bucket Number
timestamp		Time Stamp	No
daysfrom		Days From
daysto		Days To
weightage	bigint	Weightage
credit_limit		Credit Limit
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
doc_status	sql_variant	Document Status.Values A -Active,I -Inactive

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
companybu_code	sql_variant	Company Business Unit  Code	Yes	No
type_flag		Type Flag
creditterm_code		Credit Term Code
bucketno	int	Bucket Number

Table Name cm_creditterm_hdr

Table Comment Stores Information about the credit terms

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
companybu_code	sql_variant	Company Business Unit Code	Yes	No
type_flag		Type Flag
creditterm_code		Credit Term  Code
timestamp	int	Time Stamp	No
creditterm_desc	sql_variant	Credit Term  Description
single_orderlimit	bigint	Single Order Limit
total_orderlimit		Total Order Limit
dunning_reqd	sql_variant	Dunning Required
creditchk_action		Credit Check Action
creditchk_level		Credit Check Level
discntgrace_days	int	Discount Grace Days
regrace_days		Regrace Days
reswriteoff_per	bigint	Write offf per
reswriteoff_amt		Write off amount
creditterm_status	sql_variant	Credit Term Status.Values A -AuthorizedD -Deleted,F -Fresh
currency_code		Currency Code
resou_id	int	Resource Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
companybu_code	sql_variant	Company Business Unit Code	Yes	No
type_flag		Type Flag
creditterm_code		Credit Term  Code

Table Name cm_creditterm_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
bucketno	int	Bucket Number
timestamp		Time Stamp	No
daysfrom		Days From
daysto		Days To
weightage	bigint	Weightage
creditterm_code	sql_variant	Credit Term Code
credit_limit	bigint	Credit Limit
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
bucketno	int	Bucket Number

Table Name cm_cust_aging_balance_info_dtl

Table Comment Stores Information about customer ageing balance details

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
company_code	sql_variant	Company Code
bu_id		Business Unit Id
cust_code		Customer Code
bucket_no	int	Bucket Number
timestamp		Time Stamp	No
weightage	bigint	Weightage
credit_limit		Credit Limit
dr_balance_amt		Debit Balance Amount
cr_balance_amt		Credit Balance Amount
total_balance_amt		Total Balance Amount
total_credit_limit		Total Credit Limit
total_balance_type	sql_variant	Total Balance Type
type_flag		Type Flag
credit_checklvl		Credit Check Level
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
company_code	sql_variant	Company Code
bu_id		Business Unit Id
cust_code		Customer Code
bucket_no	int	Bucket Number

Table Name cm_cust_aging_balance_info_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
run_date	datetime	Run Date
run_no	int	Run Number
cust_code	sql_variant	Customer Code
bucket_no	int	Bucket Number
timestamp		Time Stamp	No
weightage	bigint	Weightage
credit_limit		Credit Limit
dr_balance_amt		Debit Balance Amount
cr_balance_amt		Credit Balance Amount
total_balance_amt		Total Balance Amount
total_credit_limit		Total Credit Limit
total_balance_type	sql_variant	Total Balance Type
type_flag		Type Flag
credit_checklvl		Credit Check Level
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
run_date	datetime	Run Date
run_no	int	Run Number
cust_code	sql_variant	Customer Code
bucket_no	int	Bucket Number

Table Name cm_cust_aging_dtl

Table Comment Stores Information about customer ageing details

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
company_code	sql_variant	Company Code
bu_id		Business Unit Id
cust_code		Customer Code
bucket_no	int	Bucket Number
currency	sql_variant	Currency
timestamp	int	Time Stamp	No
start_date	datetime	Start Date
ouid	int	Organization Unit Id
end_date	datetime	End Date
dr_amt	bigint	Debit Amount
basedr_amt		Base Debit Amount
cr_amt		Credit Amount
basecr_amt		Base Credit Amount
cust_groupcode	sql_variant	Customer Group Code
cust_name		Customer Name
type_flag		Type Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
company_code	sql_variant	Company Code
bu_id		Business Unit Id
cust_code		Customer Code
bucket_no	int	Bucket Number
currency	sql_variant	Currency

Table Name cm_cust_aging_hdr

Table Comment Stores Information about customer ageing details

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
timestamp		Time Stamp	No
run_mode	sql_variant	Run Mode
rescompbu_code		Company Bank / PTT Unit Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number

Table Name cm_cust_aging_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
run_date	datetime	Run Date
run_no	int	Run Number
cust_code	sql_variant	Customer Code
bucket_no	int	Bucket Number
currency	sql_variant	Currency
timestamp	int	Time Stamp	No
ouid		Organization Unit Id
fbid	sql_variant	Finance Book Id
start_date	datetime	Start Date
end_date		End Date
dr_amt	bigint	Debit Amount
basedr_amt		Base Debit Amount
cr_amt		Credit Amount
basecr_amt		Base Credit Amount
cust_groupcode	sql_variant	Customer Group Code
cust_name		Customer Name
type_flag		Type Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
run_date	datetime	Run Date
run_no	int	Run Number
cust_code	sql_variant	Customer Code
bucket_no	int	Bucket Number
currency	sql_variant	Currency

Table Name cm_cust_parent_info_dtl

Table Comment Stores Information about customer parent details

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
company_code	sql_variant	Company Code
bu_id		Business Unit Id
cust_code		Customer Code
level	int	Level
timestamp		Time Stamp	No
parent_cust_code	sql_variant	Parent Customer Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
run_date	datetime	Run Date	Yes	No
run_no	int	Run Number
company_code	sql_variant	Company Code
bu_id		Business Unit Id
cust_code		Customer Code
level	int	Level

Table Name cm_dunning_dtl

Table Comment Stores Information about the Dunning details of the customer

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
dunning_date	datetime	Dunning Date
sequence_no	int	Sequence Number
fb_id	sql_variant	Finance Book Id
doc_no		Document Number
doc_type		Document Type
term_no		Term Number
cust_area	int	Customer Area
timestamp		Time Stamp	No
cust_code	sql_variant	Cust Code
doc_date	datetime	Document Date
due_date		Due Date
due_amt	bigint	Due Amount
overdue_days	int	Over Due Days
currency	sql_variant	Currency
overdue_amt	bigint	Over Due Amount
prev_dunlevel	int	Previous Dunning Level
dunning_level		Dunning Level
dunning_charge	bigint	Dunning Charge
custgrp_code	sql_variant	Customer Group Code
bu_id		Business Unit Id
crdr_note_no		Credit Debit Note Number
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
dunning_date	datetime	Dunning Date
sequence_no	int	Sequence Number
fb_id	sql_variant	Finance Book Id
doc_no		Document Number
doc_type		Document Type
term_no		Term Number
cust_area	int	Customer Area

Table Name cm_dunning_hdr

Table Comment Stores Information about the Dunning details of the customer

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
dunning_date	datetime	Dunning Date
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
resou_id	int	Resource Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
dunning_date	datetime	Dunning Date
sequence_no	int	Sequence Number

Table Name cm_gendunning_dtl_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
doc_type	sql_variant	Document Type
doc_no		Document Number
currency		Currency
cust_code		Customer Code
due_no		Due Number
due_date	datetime	Due Date
overdue_days	int	Over Due Days
due_amount	bigint	Due Amount
overdue_amount		Over Due Amount
prv_dunlevel	int	Previous Dunning Level
dun_level		Dunning Level
dunning_charges	bigint	Dunning Charges
fbid	sql_variant	Finance Book Id
cust_area		Customer Area
custgroupcode		Customer Group Code
base_amount	bigint	Base Amount
parabase_amount		Parallel Base Amount
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_is_aging_report_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
run_date	datetime	Run Date
run_no	int	Run Number
cust_groupcode	sql_variant	Customer Group Code
cust_code		Customer Code
bucket_no	int	Bucket Number
currency	sql_variant	Currency
timestamp	int	Time Stamp	No
start_date	datetime	Start Date
end_date		End Date
dr_amt	bigint	Debit Amount
basedr_amt		Base Debit Amount
cr_amt		Credit Amount
basecr_amt		Base Credit Amount
cust_name	sql_variant	Customer Name
days_from	int	Days From
days_to		Days To
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
run_date	datetime	Run Date
run_no	int	Run Number
cust_groupcode	sql_variant	Customer Group Code
cust_code		Customer Code
bucket_no	int	Bucket Number
currency	sql_variant	Currency

Table Name cm_is_cbadj_receiptinfo_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
docseq_no	int	Document Sequence Number
timestamp		Time Stamp	No
request_date	datetime	Request Date
doc_type	sql_variant	Document Type
doc_no		Document Number
cust_code		Customer Code
due_date	datetime	Due Date
due_amt	bigint	Due Amount
overdue_days	int	Over Due Days
currency	sql_variant	Currency
overdue_amt	bigint	Over Due Amount
exchange_rate		Exchange Rate
base_amt		Base Amount
billing_point	sql_variant	Billing Point
fb_id		Finance Bool Id
tran_ou	int	Transaction Organization Unit
term_no	sql_variant	Term Number
tran_type		Transaction Type
writeoff_amt	bigint	Write Off Amount
writeback_amt		Write Back Amount
pbc_erate		Parallel Base Currency Exchange Rate
pbase_amt		Parallel Base Amount
receipt_no	sql_variant	Receipt Number
request_no		Request Number
receipt_ou		Receipt Organization Unit
drcrseq_no	int	Debit Credit Sequence Number
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
docseq_no	int	Document Sequence Number

Table Name cm_is_creditstatus_report_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
company_code		Company Code
bu_id		Business Unit Id
group_type		Group Type
cust_group_code		Customer Group Code
cust_code		Customer Code
timestamp	int	Time Stamp
status	sql_variant	Status
status_type		Status Type
aging_run_date	datetime	Aging Run  Date
credit_rating	bigint	Credit Rating
report_date	datetime	Report Date
cust_name	sql_variant	Customer Name
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Name cm_is_custstatusupd_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code
timestamp	int	Time Stamp	No
pick_status	sql_variant	Pickup Status
order_status		Order Status
ship_status		Ship Status
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code

Table Name cm_is_dunning_report_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
company_code	sql_variant	Company Code
bu_id		Business Unit Id
fb_id		Finance Book Id
dunning_date	datetime	Dunning Date
group_type	sql_variant	Group Type
cust_group_code		Customer Group Code
cust_code		Customer Code
dunning_level	int	Dunning Level
doc_type	sql_variant	Document Type
doc_no		Document Number
term_no		Term Number
doc_date	datetime	Document Date
due_date		Due Date
overdue_days	int	Over Due Days
overdue_amt	bigint	Over Due Amount
dunning_charge		Dunning Charges
currency	sql_variant	Currency
cust_name		Customer Name
company_name		Company Name
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_is_jvtrandtl_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
type_flag	sql_variant	Type Flag
account_code		Account Code
currency		Currency
total_amt	bigint	Total Amount
crdr_flag	sql_variant	Credit Debit Flag
exchange_rate	bigint	Exchange Rate
base_amt		Base Amount
pbc_erate		Parallel Base Currency Exchange Rate
pbc_amt		Parallel Base Currency Amount
costcenter_code	sql_variant	Cost Center Code
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_is_jvtranhdr_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
voucher_no		Voucher Number
timestamp	int	Time Stamp	No
tran_ou		Transaction Organization Unit
tran_date	datetime	Transaction Date
fb_id	sql_variant	Finance Book Id
bu_id		Business Unit Id
tran_type		Transaction Type
costcenter_code		Cost Center Code
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
remarks		Remarks
component_id		Component Id
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
voucher_no		Voucher Number

Table Name cm_parent_cust_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
level	int	Level
timestamp		Time Stamp	No
cust_code	sql_variant	Customer Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
level	int	Level

Table Name cm_parent_custrel_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code
level	int	Level
timestamp		Time Stamp	No
parent_custcode	sql_variant	Parent Customer Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code
level	int	Level

Table Name cm_postings_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	Organization Unit Id	Yes	No
tran_type	sql_variant	Transaction Type
fb_id		Finance Book Id
tran_no		Transaction Number
account_code		Account Code
timestamp	int	Time Stamp	No
drcr_flag	sql_variant	Debit Credit Flag
currency_code		Currency Code
tran_date	datetime	Transaction Date
tran_qty	bigint	Transaction Quantity
tran_amount		Transaction Amount
base_amount		Base Amount
cost_center	sql_variant	Cost Center
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
bank_code		Bank Code
origin_ou	int	Origin Organization Unit
flag	sql_variant	Flag
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
ou_id	int	Organization Unit Id	Yes	No
tran_type	sql_variant	Transaction Type
fb_id		Finance Book Id
tran_no		Transaction Number
account_code		Account Code

Table Name cm_request_dtl

Table Comment Stores Information about the requests in the system

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
request_no		Request Number
request_type		Request Type
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
doc_type	sql_variant	Document Type
doc_no		Document Number
currency		Currency
cust_code		Customer Code
cust_area	int	Customer Area
billing_point	sql_variant	Billing Point
due_no		Due Number
due_date	datetime	Due Date
due_amt	bigint	Due Amount
overdue_days	int	Over Due Days
overdue_amt	bigint	Over Due Amount
exchange_rate		Exchange Rate
pbc_erate		Parallel Base Currency Exchange Rate
provision_amt		Provision Amount
existprov_amt		Exist Provision Amount
reversal_amt		Reversal Amount
writeoff_amt		Wite Off Amount
writeback_amt		Write Back Amount
base_amt		Base Amount
doc_tran_type	sql_variant	Document Transaction Type
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
request_no		Request Number
request_type		Request Type
sequence_no	int	Sequence Number

Table Name cm_request_hdr

Table Comment Stores Information about the requests in the system

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
request_no		Request Number
request_type		Request Type
timestamp	int	Time Stamp	No
request_date	datetime	Request Date
fb_id	sql_variant	Finance Book Id
voucher_no		Voucher Number
costcenter_code		Cost Center Code
analysis_code		Analysis Code
subanalysis_code		Subanalysis Code
remarks		Remarks
request_status		Request Status.Values A -Authorized,D -Deleted,F -Fresh
total_base_amt	bigint	Total Base Amount
voucher_ou	sql_variant	Voucher Organization Unit
total_pbc_amt	bigint	Total Parallel Base Currency Amount
basecurrency_code	sql_variant	Base Currency Code
bu_id		Business Unit Id
tran_type		Transaction Type
batch_id		Batch Id
pbcurrency_code		Parallel Base Currency Code
pbc_erate	bigint	Parallel Base Currency Exchange Rate
resou_id	int	Resource Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
request_no		Request Number
request_type		Request Type

Table Name cm_request_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
doc_type	sql_variant	Document Type
doc_no		Document Number
cust_code		Customer Code
due_date	datetime	Due Date
due_amt	bigint	Due Amount
overdue_days	int	Over Due Days
currency	sql_variant	Currency
overdue_amt	bigint	Over Due Amount
existprov_amt		Exist Provision Amount
provision_amt		Provision Amount
exchange_rate		Exchange Rate
base_amt		Base Amount
billing_point	sql_variant	Billing Point
fb_id		Finance Book Id
tran_ou	int	Transaction Organization Unit
term_no	sql_variant	Term Number
tran_type		Transaction Type
writeoff_amt	bigint	Write Off Amount
writeback_amt		Write Back Amount
pbc_erate		Parallel Base Currency Exchange Rate
pbase_amt		Parallel Base Amont
reversal_amt		Reversal Amount
receipt_no	sql_variant	Receipt Number
select_flag		Select Flag
remarks		Remarks
request_no		Request Number
voucher_no		Voucher Number
request_date	datetime	Request Date
receipt_ou	sql_variant	Receipt Organization Unit
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_runaging_custinfo_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code
timestamp	int	Time Stamp	No
cust_name	sql_variant	Customer Name
cust_groupcode		Customer Group Code
type_flag		Type Flag
credit_termcode		Credit Term Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code

Table Name cm_runaging_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code
timestamp	int	Time Stamp	No
cust_name	sql_variant	Customer Name
cust_groupcode		Customer Group Code
cust_last_rundate	datetime	Customer Last Run Date
cust_checklvl	sql_variant	Customer Check Level
type_flag		Type Flag
credit_rating	bigint	Credit Rating
order_status	sql_variant	Order Status
pick_status		Pickup Status
ship_status		Ship Status
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
company_code		Company Code
bu_id		Business Unit Id
cust_code		Customer Code

Table Name cm_soexempt_mst

Table Comment Stores Information about the Sale Order exemptions reported

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	sql_variant	Company Code	Yes	No
saleorder_no		Sales Order Number
timestamp	int	Time Stamp	No
date	datetime	Date
cust_code	sql_variant	Customer Code
amount	bigint	Amount
currency_code	sql_variant	Currency Code
reason_code		Reason Code
comments		Comments
ordering_ou	int	Ordering Organization Unit
cust_area		Customer Area
action	sql_variant	Action
resou_id	int	Resource Id
createdby	sql_variant	Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date
doc_status	sql_variant	Document Status.Values A -Active,I -Inactive

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
company_code	sql_variant	Company Code	Yes	No
saleorder_no		Sales Order Number

Table Name cm_soexempt_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number
timestamp		Time Stamp	No
saleorder_no	sql_variant	Sales Order Number
date	datetime	Date
cust_code	sql_variant	Customer Code
amount	bigint	Amount
currency_code	sql_variant	Currency Code
reason_code		Reason Code
comments		Comments
ordering_point		Ordering Point
ou_id	int	Organization Unit Id
action	sql_variant	Action
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date

Table Primary Key Column Name	Table Primary Key Column Datatype	Table Primary Key Column Comment	Table Primary Key Column Is PK	Table Primary Key Column Is FK
guid	sql_variant	Guid	Yes	No
sequence_no	int	Sequence Number

Table Name cm_wf_modistatus_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	sql_variant	Guid	No	No
cust_code		Customer Code
company_code		Company Code
bu_id		Business Unit Id
status_type		Status Type

Table Name cm_writeoff_hdr_tmp

Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	Time Stamp	No	No
guid	sql_variant	Guid
tran_no		Transaction Number
currency		Currency
exchange_rate	bigint	Exchange Rate
tran_amount		Transaction Amount
tran_type	sql_variant	Transaction Type
base_amount	bigint	Base Amount
fb_id	sql_variant	Finance Book Id
tran_ou	int	Transaction Organization Unit
tran_date	datetime	Transaction Date
pbc_erate	bigint	Parallel Base Currency Exchange Rate
pbc_amount		Parallel Base Currency Amount
company_code	sql_variant	Company Code
createdby		Created By
createddate	datetime	Created Date
modifiedby	sql_variant	Modified By
modifieddate	datetime	Modified Date