Customer Prepayment Invoice

Table Name cppi_apportioned_tcd_dtl

Table Comment Table contains the TCD apportioning for each TCD documents

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

tcd_version

int

Tax Charge Discount Version

 

 

timestamp

 

Time Stamp

No

 

item_type

nvarchar(3)

Item Type

 

 

tcd_rate

bigint

Tax Charge Discount Rate

 

 

taxable_amt

 

Taxable Amount

 

 

tcd_amount

 

Tax Charge Discount Amount

 

 

tcd_currency

nvarchar(5)

Tax Charge Discount Currency

 

 

base_amount

bigint

Base Amount

 

 

par_base_amount

 

Parallel Base Amount

 

 

cost_center

nvarchar(10)

Cost Center

 

 

analysis_code

nvarchar(5)

Analysis Code

 

 

subanalysis_code

 

Subanalysis Code

 

 

remarks

nvarchar(255)

Remarks

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

tcd_version

int

Tax Charge Discount Version

 

 

Table Name cppi_ar_postings_dtl

Table Comment Table contains the info  about the account posting for customer against each Transactions

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

posting_line_no

int

Posting Line Number

 

 

timestamp

 

Time Stamp

No

 

line_no

 

Line Number

 

 

company_code

nvarchar(10)

Company Code

 

 

posting_status

nvarchar(3)

Posting Status. Values P-Posted

 

 

posting_date

datetime

Posting Date

 

 

fb_id

nvarchar(20)

Finance Book Id

 

 

tran_date

datetime

Transaction Date

 

 

account_type

nvarchar(15)

Account Type

 

 

account_code

nvarchar(32)

Account Code

 

 

drcr_id

nvarchar(1)

Debit Credit Id

 

 

tran_currency

nvarchar(5)

Transaction Currency

 

 

tran_amount

bigint

Transaction Amount

 

 

exchange_rate

 

Exchange Rate

 

 

base_amount

 

Base Amount

 

 

par_exchange_rate

 

Parallel Exchange Rate

 

 

par_base_amount

 

Parallel Base Amount

 

 

cost_center

nvarchar(10)

Cost Center

 

 

analysis_code

nvarchar(5)

Analysis Code

 

 

subanalysis_code

 

Subanalysis Code

 

 

guid

nvarchar(40)

Guid

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

Modified By

 

 

modifieddate

datetime

Modified Date

 

 

org_vat_base_amt

bigint

Organization Value Added Tax Base Amount

 

 

entry_date

datetime

Entry Date

 

 

auth_date

 

Authorized Date

 

 

item_code

nvarchar(40)

Item Code

 

 

item_variant

 

Item Variant

 

 

quantity

bigint

Quantity

 

 

reftran_fbid

nvarchar(20)

Reference Transaction Finance Book Id

 

 

reftran_no

nvarchar(40)

Reference Transaction Number

 

 

reftran_ou

int

Reference Transaction Organization Unit

 

 

cust_code

nvarchar(16)

Customer Code

 

 

reftran_type

nvarchar(10)

Reference Transaction Type

 

 

uom

nvarchar(15)

Unit Of Measurement

 

 

mac_post_flag

nvarchar(25)

Management Account Posting Flag

 

 

vat_line_no

int

Value Added Tax Line Number.

 

 

vatlineno

 

Value Added Tax Line Number

 

 

source_comp

nvarchar(20)

Source Company

 

 

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

posting_line_no

int

Posting Line Number

 

 

Table Name cppi_calc_tcd_taxdtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

company_code

nvarchar(10)

Company Code

 

 

company_baseccy

nvarchar(5)

Company Base Currency

 

 

invoice_no

nvarchar(18)

Invoice Number

 

 

refdoc_no

nvarchar(40)

Reference Document Number

 

 

amendment_no

 

Amendment Number

 

 

refdoc_ccy

nvarchar(20)

Reference Document Currency

 

 

tcd_code

nvarchar(25)

Tax Charge Discount Code

 

 

tcd_variant

nvarchar(8)

Tax Charge Discount Variant

 

 

tcd_rate

bigint

Tax Charge Discount Rate

 

 

tcd_ccy

nvarchar(5)

Tax Charge Discount Currency

 

 

tcd_appl_on

nvarchar(25)

Tax Charge Discount Application On

 

 

tcd_code_typ

 

Tax Charge Discount Code Type

 

 

tcdamt_tcdccy

bigint

Tax Charge Discount Currency

 

 

exRate_tcd2invCcy

 

Exchange Rate Tax Charge Discount Invoice Currency

 

 

tcdamt_invccy

 

Invoice Currency Amount

 

 

Table Name cppi_cim_intxn_ou_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

subouinstid

int

Suborganization Unit Instance Id

 

 

subouinstname

varchar(1)

Suborganization Unit Instance Name

 

 

subcompname

 

Subcompany Name

 

 

pubouinstid

int

Published Organization Unit Id

 

 

pubouinstname

varchar(1)

Published Organization Unit Name

 

 

pubcompname

 

Published Company Name

 

 

Table Name cppi_emod_intxn_curr_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

companycode

nvarchar(10)

Company Code

 

 

currencycode

nvarchar(5)

Currency Code

 

 

Table Name cppi_emod_intxn_fb_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

company_code

nvarchar(10)

Company Code

 

 

finance_bookid

nvarchar(20)

Finance Book Id

 

 

fb_type

nvarchar(10)

Finance Book Type

 

 

fb_desc

nvarchar(128)

Finance Book Description

 

 

fb_status

nvarchar(2)

Finance Book Status

 

 

Table Name cppi_hdl_dtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

ou_id

int

Organization Unit Id

 

 

ref_docno

nvarchar(18)

Reference Document Number

 

 

inv_cat

nvarchar(256)

Invoice Category

 

 

invoice_no

nvarchar(18)

Invoice Number

 

 

invoice_date

datetime

Invoice Date

 

 

inv_currency

nvarchar(5)

Invoice Currency

 

 

invoice_amt

bigint

Invoice Amount

 

 

status

nvarchar(40)

Status

 

 

bill_to_cust

nvarchar(16)

Bill To Customer

 

 

bill_to_cust_name

nvarchar(60)

Bill To Customer Name

 

 

fb

nvarchar(20)

Finance Book

 

 

Table Name cppi_invoice_dtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

tran_type

nvarchar(10)

Transaction Type

 

 

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

ref_doc_ou

 

Reference Document Organization Unit

 

 

ref_doc_no

nvarchar(18)

Reference Document Number

 

 

ref_doc_type

nvarchar(40)

Reference Document Type

 

 

amendment_no

int

Amendment Number

 

 

ref_doc_ccy

nvarchar(5)

Reference Document Currency

 

 

ref_doc_amt

bigint

Reference Document Amount

 

 

invoiced_amt

 

Invoiced Amount

 

 

net_order_amt

 

Net Order Amount

 

 

adv_percent

 

Advance Percentage

 

 

material_amt

 

Material Amount

 

 

resources_amt

 

Resources Amount

 

 

oth_charges_amt

 

OT Hour Charges Amount

 

 

total_adv_amt

 

Total Advance Amount

 

 

total_adv_amt_inv_ccy

 

Total Advance Amount  Invoice Currency

 

 

timestamp

int

Time Stamp

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

Modified By

 

 

modifieddate

datetime

Modified Date

 

 

Table Name cppi_invoice_hdr

Table Comment Table contains the prepayment invoice’s that are raised for a order based or direct prepayment’s.

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

invoice_cat

nvarchar(5)

Invoice Category

No

 

tran_date

datetime

Transaction Date

 

 

fb_id

nvarchar(20)

Finance Book Id

 

 

num_type

nvarchar(10)

Numbering Type

 

 

cust_ou

int

Customer Organization Unit

 

 

bill_to_cust

nvarchar(18)

Bill To Customer

 

 

ship_to_cust

 

Ship To Customer

 

 

ship_to_id

nvarchar(6)

Ship To Id

 

 

tran_currency

nvarchar(5)

Transaction Currency

 

 

is_fw_rate_applicable

nvarchar(1)

Is Forward Rate Applicable

 

 

fw_rate_type

nvarchar(10)

Forward Rate Type

 

 

fw_rate

bigint

Forward Rate

 

 

exchange_rate

 

Exchange Rate

 

 

par_exchange_rate

 

Parallel Exchange Rate

 

 

receipt_method

nvarchar(30)

Receipt Method

 

 

pay_term

nvarchar(15)

Pay Term

 

 

anchor_date

datetime

Anchor Date

 

 

ref_doc_ou

int

Reference Document Organization Unit

 

 

ref_doc_no

nvarchar(18)

Reference Document Number

 

 

comments

nvarchar(256)

Comments

 

 

base_amount

bigint

Base Amount

 

 

par_base_amount

 

Parallel Base Amount

 

 

basic_value

 

Basic Value

 

 

tran_amount

 

Transaction Amount

 

 

pre_round_off_amount

 

Pre-round Off Amount

 

 

rounded_off_amount

 

Rounded Off Amount

 

 

draft_flag

nvarchar(1)

Draft Flag

 

 

tran_status

nvarchar(3)

Transaction Status. Values AUT -Authorized, DEL -Deleted, DFT -Draft, FSH -Fresh, HAU -Held, HPR -Held Partly Paid, PD -Paid, PR -Partly Paid, RL -Released, RTD -Returned, RVD -Reversed, FAJ -Fully Adjusted, PAJ -Partly Adjusted

 

 

timestamp

int

Time Stamp

 

 

auth_date

datetime

Authorized Date

 

 

hld_date

 

Hold Date

 

 

release_date

 

Release Date

 

 

rev_date

 

Reversal Date

 

 

rev_reason_code

nvarchar(10)

Reversal Reason Code

 

 

rev_remarks

nvarchar(100)

Reversal Remarks

 

 

reasons_hold

nvarchar(10)

Reasons Hold

 

 

remarks_hold

nvarchar(100)

Remarks Hold

 

 

ordlvltax

bigint

Order Value Tax

 

 

ordlvlchrg

 

Order Value Charge

 

 

ordlvldisc

 

Order Value Discount

 

 

invlvltax

 

Invoice Value Tax

 

 

invlvlchrg

 

Invoice Value Charge

 

 

invlvldisc

 

Invoice Value Discount

 

 

batch_id

nvarchar(40)

Batch Id

 

 

rev_doc_no

nvarchar(18)

Reversal Document Number

 

 

rev_doc_ou

int

Reversal Document Organization Unit

 

 

vat_applicable

nvarchar(1)

Value Added Tax Applicable

 

 

vat_exchange_rate

bigint

Value Added Tax Exchange Rate

 

 

vat_charge

 

Value Added Tax Charge

 

 

non_vat_charge

 

Other Than Value Added Tax Charge

 

 

vat_incl

nvarchar(1)

Value Added Tax Include

 

 

average_vat_rate

bigint

Average Value Added Tax Rate

 

 

vat_excl_amount

 

Value Added Tax Charge Exclude Amount

 

 

vat_amount

 

Value Added Tax Charge Amount

 

 

vat_incl_amount

 

Value Added Tax Charge Include Amount

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

Table Name cppi_invoice_hdr_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

tran_type

nvarchar(10)

Transaction Type

 

 

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

invoice_cat

nvarchar(5)

Invoice Category

 

 

tran_date

datetime

Transaction Date

 

 

fb_id

nvarchar(20)

Finance Book Id

 

 

num_type

nvarchar(10)

Numbering Type

 

 

cust_ou

int

Customer Organization Unit

 

 

bill_to_cust

nvarchar(18)

Bill To Customer

 

 

ship_to_cust

 

Ship To Customer

 

 

ship_to_id

nvarchar(6)

Ship To Id

 

 

tran_currency

nvarchar(5)

Transaction Currency

 

 

is_fw_rate_applicable

nvarchar(1)

Is Forward Rate Applicable

 

 

fw_rate_type

nvarchar(10)

Forward Rate Type

 

 

fw_rate

bigint

Forward Rate

 

 

exchange_rate

 

Exchange Rate

 

 

par_exchange_rate

 

Parallel Exchange Rate

 

 

receipt_method

nvarchar(30)

Receipt Method

 

 

pay_term

nvarchar(15)

Pay Term

 

 

anchor_date

datetime

Anchor Date

 

 

ref_doc_ou

int

Reference Document Organization Unit

 

 

ref_doc_no

nvarchar(18)

Reference Document Number

 

 

comments

nvarchar(256)

Comments

 

 

base_amount

bigint

Base Amount

 

 

par_base_amount

 

Parallel Base Amount

 

 

basic_value

 

Basic Value

 

 

tran_amount

 

Transaction Amount

 

 

pre_round_off_amount

 

Pre-round Off Amount

 

 

rounded_off_amount

 

Rounded Off Amount

 

 

draft_flag

nvarchar(1)

Draft Flag

 

 

tran_status

nvarchar(3)

Transaction Status

 

 

timestamp

int

Time Stamp

 

 

auth_date

datetime

Authorized Date

 

 

hld_date

 

Hold Date

 

 

release_date

 

Release Date

 

 

rev_date

 

Reversal Date

 

 

rev_reason_code

nvarchar(10)

Reversal Reason Code

 

 

rev_remarks

nvarchar(100)

Reversal Remarks

 

 

reasons_hold

nvarchar(10)

Reasons Hold

 

 

remarks_hold

nvarchar(100)

Remarks Hold

 

 

ordlvltax

bigint

Order Value Tax

 

 

ordlvlchrg

 

Order Value Charge

 

 

ordlvldisc

 

Order Value Discount

 

 

invlvltax

 

Invoice Value Tax

 

 

invlvlchrg

 

Invoice Value Charge

 

 

invlvldisc

 

Invoice Value Discount

 

 

batch_id

nvarchar(40)

Batch Id

 

 

rev_doc_no

nvarchar(18)

Reversal Document Number

 

 

rev_doc_ou

int

Reversal Document Organization Unit

 

 

vat_applicable

nvarchar(1)

Value Added Tax  Applicable

 

 

vat_exchange_rate

bigint

Value Added Tax  Exchange Rate

 

 

vat_charge

 

Value Added Tax  Charge

 

 

non_vat_charge

 

Other Than Value Added Tax  Charge

 

 

vat_incl

nvarchar(1)

Value Added Tax  Include

 

 

average_vat_rate

bigint

Average Value Added Tax  Rate

 

 

vat_excl_amount

 

Value Added Tax  Exclude Amount

 

 

vat_amount

 

Value Added Tax  Amount

 

 

vat_incl_amount

 

Value Added Tax  Include Amount

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

Modified By

 

 

modifieddate

datetime

Modified Date

 

 

onmat_taxkey

varchar(18)

TRN-Bsg-RCN-CPPI-R62-1.0 On Material Taxkey

 

 

onlab_taxkey

 

TRN-Bsg-RCN-CPPI-R62-1.0 On Labour Taxkey

 

 

ondoc_taxkey

 

TRN-Bsg-RCN-CPPI-R62-1.0 On DocumentTaxkey

 

 

Table Name cppi_item_dtl

Table Comment Table that contains the customer orders that are user for order based prepayments.

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

ref_doc_ou

 

Reference Document Organization Unit

No

 

ref_doc_no

nvarchar(18)

Reference Document Number

 

 

ref_doc_type

nvarchar(40)

Reference Document Type

 

 

amendment_no

int

Amendment Number

 

 

ref_doc_ccy

nvarchar(5)

Reference Document Currency

 

 

ref_doc_amt

bigint

Reference Document Amount

 

 

invoiced_amt

 

Invoiced Amount

 

 

net_order_amt

 

Net Order Amount

 

 

adv_percent

 

Advance Percentage

 

 

material_amt

 

Material Amount

 

 

resources_amt

 

Resources Amount

 

 

oth_charges_amt

 

OT Hours Charges Amount

 

 

total_adv_amt

 

Total Advance Amount

 

 

total_adv_amt_inv_ccy

 

Total Advance Amount Invoice Currency

 

 

timestamp

int

Time Stamp

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

Table Name cppi_item_intxn_itemtype_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

item_type

nvarchar(25)

Item Type

 

 

Table Name cppi_nc_intxn_numtypes_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

num_type

nvarchar(25)

Numering Type

 

 

Table Name cppi_notes_dtl

Table Comment Table that containst the notes and comments details for the Document number

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

note_category

nvarchar(15)

Note Category

 

 

category_value

nvarchar(40)

Category Value

 

 

line_no

int

Line Number

 

 

timestamp

 

Time Stamp

No

 

note_text

nvarchar(2000)

Note Text

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

note_category

nvarchar(15)

Note Category

 

 

category_value

nvarchar(40)

Category Value

 

 

line_no

int

Line Number

 

 

Table Name cppi_payment_dtl

Table Comment Table contains the payterm and the due_amount for each document number

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

term_no

nvarchar(20)

Term Number

 

 

timestamp

int

Time Stamp

No

 

posting_status

nvarchar(3)

Posting Status. Values P-Posted

 

 

posting_date

datetime

Posting Date

 

 

due_date

 

Due Date

 

 

due_amount_type

nvarchar(1)

Due Amount Type

 

 

due_percent

bigint

Due Percentage

 

 

due_amount

 

Due Amount

 

 

disc_comp_amount

 

Discount Company Amount

 

 

disc_amount_type

nvarchar(1)

Discount Amount Type

 

 

disc_date

datetime

Discount Date

 

 

disc_percent

bigint

Discount Percentage

 

 

disc_amount

 

Discount Amount

 

 

penalty_percent

 

Penalty Percentage

 

 

esr_ref_no

nvarchar(30)

ESR Reference Number

 

 

esr_coding_line

nvarchar(128)

ESR Coding Line

 

 

base_due_amount

bigint

Base Due Amount

 

 

base_disc_amount

 

Base Discount Amount

 

 

guid

nvarchar(40)

Guid

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

Modified By

 

 

modifieddate

datetime

Modified Date

 

 

esr_amount

bigint

ESR Amount

 

 

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

term_no

nvarchar(20)

Term Number

 

 

Table Name cppi_payment_dtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

term_no

nvarchar(15)

Term Numbe

No

No

due_date

datetime

Due Date

 

 

due_amount_type

nvarchar(40)

Due Amount Type

 

 

due_percentage

bigint

Due Percentage

 

 

due_amount

 

Due Amount

 

 

disc_comp_amount

 

Discount Company Amount

 

 

disc_amount_type

nvarchar(40)

Discount Amount Type

 

 

discount_date

datetime

Discount Date

 

 

discount_percentage

bigint

Discount Percentage

 

 

discount_amount

 

Discount Amount

 

 

penalty_percentage

 

Penalty Percentage

 

 

esr_ref_no

nvarchar(40)

ESR Reference Number

 

 

esr_coding_line

int

ESR Coding Line

 

 

adjusted_amount

bigint

Adjusted Amount

 

 

tran_ou

int

Transaction Organization Unit

 

 

tran_type

nvarchar(25)

Transaction Type

 

 

guid

nvarchar(40)

Guid

 

 

tran_no

 

Transaction Number

 

 

payterm_lineno

int

Pay Term Line Number

 

 

Table Name cppi_price_disc_in_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

disc_guid

nvarchar(40)

Discount Guid

No

No

disc_login_ou

int

Discount Login Organization Unit

 

 

disc_info_level

nvarchar(8)

Discount Information Level

 

 

disc_doc_line_no

int

Discount Document Line Number

 

 

disc_item_ou

 

Discount Item Organization Unit

 

 

disc_item_type

nvarchar(25)

Discount Item Type

 

 

disc_item_code

nvarchar(40)

Discount Item Code

 

 

disc_item_group

nvarchar(25)

Discount Item Group

 

 

disc_item_variant

nvarchar(8)

Discount Item Variant

 

 

disc_uom

nvarchar(10)

Discount Unit Of Measurement

 

 

disc_qty

bigint

Discount Quantity

 

 

disc_rate

 

Discount Rate

 

 

disc_pricing_date

datetime

Discount Pricing Date

 

 

disc_ordcustomer_ou

int

Discount Order Customer Organization Unit

 

 

disc_billcustomer_ou

 

Discount  Bill Customer Organization Unit

 

 

disc_shipcustomer_ou

 

Discount Ship Customer Organization Unit

 

 

disc_ordcustomer_code

nvarchar(16)

Discount Order Customer Code

 

 

disc_billcustomer_code

 

Discount Bill Customer Code

 

 

disc_shipcustomer_code

 

Discount Ship Customer Code

 

 

disc_shipping_point

int

Discount Shipping Point

 

 

disc_shipping_wh

nvarchar(10)

 

 

 

disc_delivery_area

nvarchar(18)

Discount Delivery Area

 

 

disc_sales_channel

nvarchar(15)

Discount Sales Channel

 

 

disc_currency

nvarchar(5)

Discount Currency

 

 

disc_doc_amount

bigint

Discount Document Amount

 

 

disc_op_param1

nvarchar(100)

Optional Parameter 1

 

 

disc_op_param2

 

Optional Parameter 2

 

 

disc_op_param3

 

Optional Parameter 3

 

 

disc_op_param4

datetime

Optional Parameter 4

 

 

Table Name cppi_price_engine_in_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

price_guid

nvarchar(40)

Guid

No

No

price_login_ou

int

Login Organization Unit

 

 

price_info_level

nvarchar(8)

Information Level

 

 

price_doc_line_no

int

Document Line Number

 

 

price_item_ou

 

Item Organization Unit

 

 

price_item_type

nvarchar(25)

Item Type

 

 

price_item_code

nvarchar(40)

Item Code

 

 

price_item_group

nvarchar(25)

Item Group

 

 

price_item_variant

nvarchar(8)

Item Variant

 

 

price_uom

nvarchar(10)

Unit Of Measurement

 

 

price_qty

bigint

Quantity

 

 

price_unit_rate

 

Unit Rate

 

 

price_default_price

nvarchar(8)

Default Price

 

 

price_default_promotion

 

Default Promotion

 

 

price_pricing_date

datetime

Pricing Date

 

 

price_ordcustomer_ou

int

Order Customer Organization Unit

 

 

price_billcustomer_ou

 

Bill Customer Organization Unit

 

 

price_shipcustomer_ou

 

Ship Customer Organization Unit

 

 

price_ordcustomer_code

nvarchar(16)

Order Customer Code

 

 

price_billcustomer_code

 

Bill Customer Code

 

 

price_shipcustomer_code

 

Ship Customer Code

 

 

price_shipping_point

int

Shipping Point

 

 

price_shipping_wh

nvarchar(10)

 

 

 

price_delivery_area

nvarchar(18)

Delivery Area

 

 

price_sales_channel

nvarchar(15)

Sales Channel

 

 

price_currency

nvarchar(5)

Currency

 

 

price_pricelist_code

nvarchar(25)

Price List Code

 

 

price_ref_doc_type

nvarchar(20)

Reference Document Type

 

 

price_ref_doc_no

nvarchar(40)

Reference Document Number

 

 

price_ref_doc_ou

int

Reference Document Organization Unit

 

 

price_ref_doc_lineno

 

Reference Document Line Number

 

 

price_op_param1

nvarchar(100)

Optional Parameter 1

 

 

price_op_param2

 

Optional Parameter 2

 

 

price_op_param3

 

Optional Parameter 3

 

 

price_op_param4

datetime

Optional Parameter 4

 

 

Table Name cppi_price_fet_attr_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

price_guid

nvarchar(40)

Guid

No

No

price_login_ou

int

Login Organization Unit

 

 

price_doc_line_no

 

Document Line Number

 

 

price_attrib_line_no

 

Attribute Line Number

 

 

price_attribute_code

nvarchar(6)

Attribute Code

 

 

price_qualitative_value

nvarchar(20)

Qualitative Value

 

 

price_min_value

bigint

Minimum Value

 

 

price_max_value

 

Maximum Value

 

 

Table Name cppi_price_fetch_in_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

price_guid

nvarchar(40)

Guid

No

No

price_login_ou

int

Login Organization Unit

 

 

price_doc_line_no

 

Document Line Number

 

 

price_ordcustomer_ou

 

Order Customer Organization Unit

 

 

price_billcustomer_ou

 

Bill Customer Organization Unit

 

 

price_shipcustomer_ou

 

Ship Customer Organization Unit

 

 

price_ordcustomer_code

nvarchar(16)

Order Customer Code

 

 

price_billcustomer_code

 

Bill Customer Code

 

 

price_shipcustomer_code

 

Ship Customer Code

 

 

price_pricelist_code

nvarchar(25)

Price List Code

 

 

price_currency

nvarchar(5)

Currency

 

 

price_tran_date

datetime

Transaction Date

 

 

price_item_ou

int

Item Organization Unit

 

 

price_item_type

nvarchar(25)

Item Type

 

 

price_item_code

nvarchar(40)

Item Code

 

 

price_item_group

nvarchar(25)

Item Group

 

 

price_item_variant

nvarchar(8)

Item Variant

 

 

price_uom

nvarchar(10)

Unit Of Measurement

 

 

price_qty

bigint

Quantity

 

 

Table Name cppi_price_tc_in_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tc_guid

nvarchar(40)

Guid

No

No

tc_login_ou

int

Login Organization Unit

 

 

tc_info_level

nvarchar(8)

Information Level

 

 

tc_doc_line_no

int

Document Line Number

 

 

tc_ref_doc_type

nvarchar(20)

Reference Document Type

 

 

tc_item_ou

int

Item Organization Unit

 

 

tc_item_type

nvarchar(25)

Item Type

 

 

tc_item_code

nvarchar(40)

Item Code

 

 

tc_item_group

nvarchar(25)

Item Group

 

 

tc_item_variant

nvarchar(8)

Item Variant

 

 

tc_uom

nvarchar(10)

Unit Of Measurement

 

 

tc_qty

bigint

Quantity

 

 

tc_default_tax_flag

nvarchar(8)

Default Tax Flag

 

 

tc_default_chrg_flag

 

Default Charge Flag

 

 

tc_tran_date

datetime

Transaction Date

 

 

tc_ordcustomer_ou

int

Order Customer Organization Unit

 

 

tc_billcustomer_ou

 

Bill Customer Organization Unit

 

 

tc_shipcustomer_ou

 

Ship Customer Organization Unit

 

 

tc_ordcustomer_code

nvarchar(16)

Order Customer Code

 

 

tc_billcustomer_code

 

Bill Customer Code

 

 

tc_shipcustomer_code

 

Ship Customer Unit

 

 

tc_shipping_point

int

Shipping Point

 

 

tc_shipping_wh

nvarchar(10)

 

 

 

tc_delivery_area

nvarchar(18)

Delivery Area

 

 

tc_sales_channel

nvarchar(15)

Sales Channel

 

 

tc_site_id

nvarchar(40)

Site Id

 

 

tc_recv_ou

int

Received Organization Unit

 

 

tc_currency

nvarchar(5)

Currency

 

 

tc_doc_amount

bigint

Document Amount

 

 

tc_op_param1

nvarchar(100)

Optional Parameter 1

 

 

tc_op_param2

 

Optional Parameter 2

 

 

tc_op_param3

 

Optional Parameter 3

 

 

tc_op_param4

datetime

Optional Parameter 4

 

 

Table Name cppi_pt_intxn_paydtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

ouid

int

Organization Unit Id

 

 

pay_term

nvarchar(15)

Pay Term

 

 

pay_term_no

 

Pay Term Number

 

 

due_days

int

Due Days

 

 

due_percentage

bigint

Due Percentage

 

 

discount_days

int

Discount Days

 

 

discount_percentage

bigint

Discount Percentage

 

 

penalty_percentage

 

Penalty Percentage

 

 

disc_proportional

nvarchar(25)

Discount Proportional

 

 

Table Name cppi_qcd_intxn_codes_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

tran_type

nvarchar(25)

Transaction Type

 

 

reason_code

nvarchar(10)

Reason Code

 

 

reason_desc

nvarchar(256)

Reason Description

 

 

Table Name cppi_so_dtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

so_order_no

 

Order Number

 

 

so_ou

int

Organization Unit

 

 

so_amend_no

 

Amend Number

 

 

so_date

datetime

Date

 

 

bill_to_customer

nvarchar(16)

Bill To Customer

 

 

so_currency

nvarchar(5)

Currency

 

 

ship_to_cusomter

nvarchar(16)

Ship To Customer

 

 

ship_id

nvarchar(6)

Ship Id

 

 

so_line_no

int

Line Number

 

 

item_type

nvarchar(25)

Item Type

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_variant

 

Item Tax Charge Discount Variant

 

 

uom

nvarchar(15)

Unit Of Measurement

 

 

quantity

bigint

Quantity

 

 

price

 

Price

 

 

analysis_code

nvarchar(5)

Analysis Code

 

 

sub_analysis_code

 

Subanalysis Code

 

 

cost_center

nvarchar(10)

Cost Center

 

 

item_tcd

nvarchar(40)

Item Tax Charge Discount

 

 

tcd_compute

 

Tax Charge Discount Compute

 

 

tcd_on_line_no

int

Tax Charge Discount On Line Number

 

 

tcdtrate

bigint

Tax Charge Discount Rate

 

 

tcdamount

 

Tax Charge Discount Amount

 

 

taxabl_amount

 

Taxable Amount

 

 

tcd_type

nvarchar(25)

Tax Charge Discount Type

 

 

item_tax

bigint

Item Tax

 

 

item_charge

 

Item Charge

 

 

item_discount

 

Item Discount

 

 

item_vat

 

Item  Value Added Tax

 

 

amount

 

Amount

 

 

Table Name cppi_so_order_no_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

so_no

 

Number

 

 

invoice_category

 

Invoice Category

 

 

bill_to_cust

nvarchar(18)

Bill To Customer

 

 

so_currency

nvarchar(5)

Currency

 

 

so_exch_rate

bigint

Exchange Rate

 

 

so_pay_term

nvarchar(15)

Pay Terrm

 

 

so_ou

int

Organization Unit

 

 

amend_no

nvarchar(18)

Amendment Number

 

 

Table Name cppi_tcd_dtl

Table Comment Table that contains the TCD info for each documents that has TCD attachments

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

item_tcd_level

 

Item Tax Charge Discount Level

No

 

timestamp

int

Time Stamp

 

 

item_type

nvarchar(3)

Item Type

 

 

tcd_applon

nvarchar(5)

Tax Charge Discount Application On

 

 

tcd_rate

bigint

Tax Charge Discount Rate

 

 

taxable_amount

 

Taxable Amount

 

 

tcd_amount

 

Tax Charge Discount Amount

 

 

tcd_currency

nvarchar(5)

Tax Charge Discount Currency

 

 

tcd_amt_inv

bigint

Tax Charge Discount Amount  Invoice

 

 

cost_center

nvarchar(10)

Cost Center

 

 

analysis_code

nvarchar(5)

Analysis Code

 

 

subanalysis_code

 

Subanalysis Code

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

Table Name cppi_tcd_dtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

guid

nvarchar(40)

Guid

No

No

tran_type

nvarchar(10)

Transaction Type

 

 

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

line_no

int

Line Number

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

item_tcd_level

 

Item Tax Charge Discount Level

 

 

timestamp

int

Time Stamp

 

 

item_type

nvarchar(3)

Item Type

 

 

tcd_applon

nvarchar(5)

Tax Charge Discount Application On

 

 

tcd_rate

bigint

Tax Charge Discount Rate

 

 

taxable_amount

 

Taxable Amount

 

 

tcd_amount

 

Tax Charge Discount Amount

 

 

tcd_currency

nvarchar(5)

Tax Charge Discount Currency

 

 

tcd_amt_inv

bigint

Tax Charge Discount Amount Invoice

 

 

cost_center

nvarchar(10)

Cost Center

 

 

analysis_code

nvarchar(5)

Analysis Code

 

 

subanalysis_code

 

Subanalysis Code

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

Modified By

 

 

modifieddate

datetime

Modified Date

 

 

tax_type

nvarchar(25)

TRN-Bsg-RCN-CPPI-R62-1.0 Tax type

 

 

Table Name cppi_tcdcal_calcprocess_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tcdcal_guid

nvarchar(40)

Guid

No

No

tcdcal_tcdcode

nvarchar(10)

Tax Charge Discount Code

 

 

tcdcal_tcddocumentlevel

 

Tax Charge Discount Document Level

 

 

tcdcal_tcdvariant

 

Tax Charge Discount Variant

 

 

tcdcal_line_no

int

Line Number

 

 

tcdcal_tcdvalue

bigint

Tax Charge Discount Value

 

 

tcdcal_bv_lineitem

 

Line Item

 

 

tcdcal_qty_lineitem

 

Quantity Line Item

 

 

tcdcal_tcd_amount

 

Tax Charge Discount Amount

 

 

Table Name cppi_vat_dtl

Table Comment Table contains the VAT details for each document number

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

vat_line_no

int

Value Added Tax Line Number

 

 

timestamp

 

Time Stamp

No

 

doc_line_no

 

Document Line Number

 

 

item_type

nvarchar(3)

Item Type

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

vat_category

 

Value Added Tax Category

 

 

vat_class

 

Value Added Tax Class

 

 

tcd_var

 

Tax Charge Discount Variant

 

 

vat_rate

bigint

Value Added Tax Rate

 

 

inp_vat_deduct_per

 

Input Value Added Tax Deduction Percentage

 

 

item_amount

 

Item Amount

 

 

vat_item_charge

 

Value Added Tax Item Charge

 

 

non_vat_item_charge

 

Other Than Value Added Tax Item Charge

 

 

vat_dist_charge

 

Value Added Tax Distributed Charge

 

 

item_level_disc_amount

 

Item Level Discount Amount

 

 

dist_disc_amount

 

Distributed Discount Amount

 

 

vat_tran_amount

 

Value Added Tax Transaction Amount

 

 

corr_vat_tran_amount

 

Corrected Value Added Tax Transaction Amount

 

 

vat_base_amount

 

Value Added Tax Base Amount

 

 

corr_vat_base_amount

 

Corrected Value Added Tax Base Amount

 

 

account_code

nvarchar(32)

Account Code

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

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

tran_type

nvarchar(10)

Transaction Type

Yes

No

tran_ou

int

Transaction Organization Unit

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

vat_line_no

int

Value Added Tax Line Number

 

 

Table Name cppi_vat_dtl_tmp

Table Column Name

Table Column Datatype

Table Column Comment

Table Column Is PK

Table Column Is FK

timestamp

int

Time Stamp

No

No

tran_ou

 

Transaction Organization Unit

 

 

tran_type

nvarchar(10)

Transaction Type

 

 

tran_no

nvarchar(18)

Transaction Number

 

 

doc_line_no

int

Document Line Number

 

 

item_type

nvarchar(3)

Item Type

 

 

account_code

nvarchar(32)

Account Code

 

 

item_tcd_code

nvarchar(40)

Item Tax Charge Discount Code

 

 

item_tcd_var

 

Item Tax Charge Discount Variant

 

 

vat_category

 

Value Added Tax Category

 

 

vat_class

 

Value Added Tax Class

 

 

tcd_var

 

Tax Charge Discount Variant

 

 

vat_rate

bigint

Tax Charge Discount Rate

 

 

inp_vat_deduct_per

 

Input Value Added Tax Deduction Per

 

 

item_amount

 

Item Amount

 

 

vat_item_charge

 

Value Added Tax Item Charge

 

 

non_vat_item_charge

 

Other Than Value Added Tax Item Charge

 

 

vat_dist_charge

 

Value Added Tax Distributed Charge

 

 

item_level_disc_amount

 

Item Level Discount Amount

 

 

dist_disc_amount

 

Distributed Discount Amount

 

 

vat_tran_amount

 

Value Added Tax Transaction Amount

 

 

corr_vat_tran_amount

 

Corrected Value Added Tax Transaction Amount

 

 

vat_base_amount

 

Value Added Tax Base Amount

 

 

corr_vat_base_amount

 

Corrected Value Added Tax Base Amount

 

 

createdby

nvarchar(15)

Created By

 

 

createddate

datetime

Created Date

 

 

modifiedby

nvarchar(15)

Modified By

 

 

modifieddate

datetime

Modified Date

 

 

vat_line_no

int

Value Added Tax Line Number

 

 

guid

nvarchar(40)

Guid

 

 

item_tcd_desc

 

Item Tax Charge Discount Description