|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction Type | No |
| tran_ou | fin_ouinstid | int(4) | No | Organization Unit Id | No |
| tran_no | fin_documentnumber | varchar(18) | No | Transaction Number | No |
| tran_status | fin_status | varchar(25) | No | Transaction Status | No |
| tran_date | fin_date | datetime(8) | No | Transaction Date | No |
| no_type | fin_notypeno | varchar(10) | No | Numbering Type | No |
| anchor_date | fin_date | datetime(8) | No | anchor date | No |
| fb_id | fin_financebookid | varchar(20) | No | Finance Book | No |
| inv_category | fin_category | varchar(15) | No | Invoice Category | No |
| doc_type | fin_doctype | varchar(40) | No | Document Type | No |
| inv_subtype | fin_designparamcode | varchar(5) | No | Invocie Subtype | No |
| refdoc_type | fin_doctype | varchar(40) | No | Reference Document type | No |
| bill_to_cust | fin_customer_id | varchar(18) | No | Bill to customer | No |
| ship_to_cust | fin_customer_id | varchar(18) | No | Ship to customer | No |
| tran_currency | fin_currencycode | varchar(5) | No | Transaction Currency | No |
| exchange_rate | fin_exchangerate | numeric(9) | No | Exchange rate | No |
| pay_term | fin_paytermcode | varchar(15) | No | Pay term | No |
| payterm_version | fin_lineno | int(4) | No | Payterm version | No |
| receipt_method | fin_method | varchar(30) | No | Receipt method | No |
| receipt_mode | fin_receiptmode | varchar(25) | No | Receipt mode | No |
| comments | fin_lngremarks | varchar(2000) | No | Comments | No |
| ord_mat_amt | fin_amount | numeric(13) | No | Order Material amount | No |
| ord_lab_amt | fin_amount | numeric(13) | No | Order Labour amount | No |
| ord_res_othamt | fin_amount | numeric(13) | No | Order resource other amount | No |
| ord_ext_repamt | fin_amount | numeric(13) | No | Order external repair amount | No |
| ord_ext_seramt | fin_amount | numeric(13) | No | Order external service amount | No |
| ord_addln_chrgamt | fin_amount | numeric(13) | No | Order additional charge amount | No |
| ord_fixed_price | fin_amount | numeric(13) | No | Order fixed price amount | No |
| item_amount | fin_amount | numeric(13) | No | Item amount | No |
| ord_tax_amt | fin_amount | numeric(13) | No | Order tax amount | No |
| ord_chrg_amt | fin_amount | numeric(13) | No | Order charge amount | No |
| ord_disc_amt | fin_amount | numeric(13) | No | Order discount amount | No |
| inv_tax_amt | fin_amount | numeric(13) | No | Invoice taxable amount | No |
| inv_chrg_amt | fin_amount | numeric(13) | No | Invoice charge amount | No |
| inv_disc_amount | fin_amount | numeric(13) | No | Invoice discount amount | No |
| tran_amount | fin_amount | numeric(13) | No | transaction amount | No |
| base_amount | fin_amount | numeric(13) | No | base amount | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | No | Parallel Exchange rate | No |
| par_base_amount | fin_amount | numeric(13) | No | Parallel base amount | No |
| draft_flag | bit | Bit(1) | No | Draft Flag | No |
| auto_adjust | bit | Bit(1) | No | Auto adjustment | No |
| rev_doc_no | fin_documentno | varchar(40) | No | Reversal Document Number | No |
| rev_doc_ou | fin_ouinstid | int(4) | No | Reversal Document Organization Unit Id | No |
| rev_date | fin_date | datetime(8) | No | Reversal Date | No |
| rev_reason_code | fin_quickcodes | varchar(25) | No | reversal Reason code | No |
| rev_remarks | fin_lngremarks | varchar(2000) | No | Reversal Remarks | No |
| ref_doc_no | fin_documentno | varchar(40) | No | Reference Document Number | No |
| ref_doc_ou | fin_ouinstid | int(4) | No | Reference Document Organization Unit Id | No |
| hld_date | fin_date | datetime(8) | No | Hold date | No |
| hld_reason_code | fin_quickcodes | varchar(25) | No | Hold Reason code | No |
| hld_remarks | fin_lngremarks | varchar(2000) | No | Hold remarks | No |
| auth_date | fin_date | datetime(8) | No | Authorize Date | No |
| guid | fin_guid | varchar(40) | No | Guid | No |
| timestamp | fin_int | int(4) | No | Timestamp | No |
| createdby | fin_ctxt_user | varchar(30) | No | Created By | No |
| createddate | fin_date | datetime(8) | No | Created Date | No |
| modifiedby | fin_ctxt_user | varchar(30) | No | Modified By | No |
| modifieddate | fin_date | datetime(8) | No | Modified Date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| pp_adj | fin_flag | varchar(25) | Yes | Prepayment Adjustment | No |
| item_amount_base | fin_amount | numeric(13) | Yes | Item Amount Base | No | |
| Table Name : | csi_payment_dtl |
| Comment : | Customer Invoice - Payment detail table |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | Yes | Transaction Type | No |
| tran_ou | fin_ouinstid | int(4) | Yes | Organization Unit Id | No |
| tran_no | fin_documentnumber | varchar(18) | Yes | Transaction Number | No |
| term_no | fin_termnumber | varchar(20) | Yes | Term Number | No |
| posting_date | fin_date | datetime(8) | Yes | Posting Date | No |
| due_date | fin_date | datetime(8) | Yes | Due Date | No |
| due_amount_type | fin_chkflag | varchar(1) | Yes | Due Amount Type | No |
| due_percent | fin_duepercentage | numeric(13) | Yes | Due Percentage | No |
| due_amount | fin_amount | numeric(13) | Yes | Due amount | No |
| disc_comp_amount | fin_amount | numeric(13) | Yes | Discount Computation Amount | No |
| disc_amount_type | fin_chkflag | varchar(1) | Yes | Discount Amount Type | No |
| disc_date | fin_date | datetime(8) | Yes | Discount Date | No |
| disc_percent | fin_discountpercentage | numeric(13) | Yes | Discount Percentage | No |
| disc_amount | fin_amount | numeric(13) | Yes | Discount Amount | No |
| penalty_percent | fin_penalty | numeric(13) | Yes | Penalty Percentage | No |
| base_due_amount | fin_amount | numeric(13) | Yes | Base Due Amount | No |
| base_disc_amount | fin_amount | numeric(13) | Yes | Base Discount Amount | No |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created By | No |
| createddate | fin_date | datetime(8) | Yes | Created Date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified By | No |
| modifieddate | fin_date | datetime(8) | Yes | Modified Date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Table Name : | csi_release_info |
| Comment : | Customer Order based Invoice - Detail table |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | Yes | Transaction Type | No |
| tran_ou | fin_ouinstid | int(4) | Yes | Organization Unit Id | No |
| tran_no | fin_documentnumber | varchar(18) | Yes | Transaction Number | No |
| line_no | fin_lineno | int(4) | Yes | Line Number | No |
| inv_category | fin_category | varchar(15) | Yes | Invoice category | No |
| ref_doc_type | fin_desc40 | varchar(40) | Yes | Reference Document type | No |
| ref_doc_no | fin_documentno | varchar(40) | Yes | Reference Document Number | No |
| ref_doc_date | fin_datetime | datetime(8) | Yes | Reference Document Date | No |
| rel_no | fin_int | int(4) | Yes | Release Number | No |
| rel_date | fin_datetime | datetime(8) | Yes | Release Date | No |
| ord_cur | fin_currencycode | varchar(5) | Yes | Orderd Currency | No |
| ref_docamt_ordcur | fin_amount | numeric(13) | Yes | Reference Document amount | No |
| ord_mat_amt | fin_amount | numeric(13) | Yes | Order Material amount | No |
| ord_lab_amt | fin_amount | numeric(13) | Yes | Order Labour amount | No |
| ord_res_othamt | fin_amount | numeric(13) | Yes | Order resource other amount | No |
| ord_ext_repamt | fin_amount | numeric(13) | Yes | Order external repair amount | No |
| ord_ext_seramt | fin_amount | numeric(13) | Yes | Order external service amount | No |
| ord_addln_chrgamt | fin_amount | numeric(13) | Yes | Order additional charge amount | No |
| ord_fixed_price | fin_amount | numeric(13) | Yes | Order fixed price amount | No |
| ord_tax_amt | fin_amount | numeric(13) | Yes | Order taxable amount | No |
| ord_chrg_amt | fin_amount | numeric(13) | Yes | Order charge amount | No |
| ord_disc_amt | fin_amount | numeric(13) | Yes | Order discount amount | No |
| ord_inv_erate | fin_exchangerate | numeric(9) | Yes | Order Invoice exchange rate | No |
| amt_invcur | fin_amount | numeric(13) | Yes | Invoice amount | No |
| rel_remarks | fin_notes | varchar(2000) | Yes | Remarks | No |
| res_invcurr | fin_amount | numeric(13) | Yes | Resource amount | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created By | No |
| createddate | fin_date | datetime(8) | Yes | Created Date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified By | No |
| modifieddate | fin_date | datetime(8) | Yes | Modified Date | No |
| inv_type | fin_doctype | varchar(40) | Yes | Invoice type | No |
| inv_subtype | fin_designparamcode | varchar(5) | Yes | Invoice subtype | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Table Name : | csi_tcd_dtl |
| Comment : | Customer Invoice - TCD detail table |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| tran_type | fin_cmntrantype | varchar(10) | Yes | Transaction Type | No |
| tran_ou | fin_ouinstid | int(4) | Yes | Organization Unit Id | No |
| tran_no | fin_documentnumber | varchar(18) | Yes | Transaction Number | No |
| line_no | fin_lineno | int(4) | Yes | Line Number | No |
| tcd_on | fin_designparamcode | varchar(5) | Yes | TCD On | No |
| tcd_code | fin_itemcode | varchar(40) | Yes | TCD Code | No |
| item_tcd_var | fin_itemcode | varchar(40) | Yes | TCD variant | No |
| tcd_varcode_desc | fin_vardesc | varchar(80) | Yes | TCD Variant code Description | No |
| item_type | fin_abbreviation | varchar(3) | Yes | Item Type | No |
| tcd_level | fin_chkflag | varchar(1) | Yes | TCD Level | No |
| tcd_rate | fin_amount | numeric(13) | Yes | TCD Rate | No |
| taxable_amount | fin_amount | numeric(13) | Yes | Taxable amount | No |
| tcd_currency | fin_currency | varchar(5) | Yes | TCD Currency | No |
| tcd_amount | fin_amount | numeric(13) | Yes | TCD Amount | No |
| tcd_invcur_erate | fin_exchangerate | numeric(9) | Yes | TCD Invoice currency Exchange Rate | No |
| tcd_amt_invcurr | fin_amount | numeric(13) | Yes | TCD amount Invoice Currency | No |
| tcd_bascur_erate | fin_exchangerate | numeric(9) | Yes | TCD Base currency Exchange Rate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| par_base_amount | fin_amount | numeric(13) | Yes | Parallel base amount | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost Center | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis Code | No |
| subanalysis_code | fin_subanalysiscode | varchar(5) | Yes | Subanalysis Code | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created By | No |
| createddate | fin_date | datetime(8) | Yes | Created Date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified By | No |
| modifieddate | fin_date | datetime(8) | Yes | Modified Date | No |
| fprowno | fin_rowno | int(4) | Yes | Fprowno | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes |
| org_taxable_amount | fin_amount | numeric(13) | Yes | org_taxable_amount | No |