Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ou_id | int | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| trantype | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esrpid | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esrrefno | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| invamt | bigint | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vendorcode | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vendordesc | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| paytosupp | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| paytosuppname | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_ptt_digits | int | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_ref_digits | int | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name esr_invoice_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| recno | int | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcdcode | sql_variant | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| variant | sql_variant | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcdbasis | varchar(20) | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcdvalue | bigint | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcdamount | bigint | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NULL | No | No |
Subject Area Table/View Name fin_inv_tcd_process_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_on | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NOT NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_fb_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_current_os | bigint | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_supp_ou | int | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_current_os | bigint | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_fb_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_adjustments_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_supp_ou | int | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_line_no | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| company_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| fb_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| account_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| account_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| drcr_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| cost_center | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| analysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| subanalysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| entry_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| auth_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_variant | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| quantity | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| uom | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| org_vat_base_amt | bigint | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_ap_postings_dtl
Subject Area Table/View Comment Table that maintains the posting level info and Amounts for each Transaction numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_line_no | int | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_code | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_var | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_version | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NOT NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| taxable_amt | bigint | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| cost_center | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| analysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| subanalysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| remarks | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_apportioned_tcd_dtl
Subject Area Table/View Comment Table contains the TCD apportioning for each TCD documents
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rec_doc_ou | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rec_doc_no | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rec_doc_line_no | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| order_ou | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| order_no | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| order_line_no | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| order_amendment_no | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_code | sql_variant | NOT NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_var | sql_variant | NOT NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_type | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| invoice_qty | bigint | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| invoice_amount | bigint | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| proposed_qty | bigint | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| proposed_rate | numeric(28,8) | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| proposed_amount | bigint | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name Sri_inv_refdoc_map
Subject Area Table/View Comment An interface table to store both invoice,refdocument information. This table has been introduced as part of denormalization. This table is populated on invoice authorization
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ReceiptNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ReceiptDate | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PartNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PartDesc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PartType | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| FacObjectNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| FacObjectType | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PropQuantity | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Uom | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| SerialNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| LotNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PartStatus | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PropAmount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| InvQuantity | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| InvAmount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| BerAmount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| SalvageAmount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ReceiptStatus | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| DeleteFlag | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NOT NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| invoce_cat | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| num_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| anchor_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| fb_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| auto_adjust | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| batch_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pay_term | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| elec_pay | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pay_method | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pay_priority | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| payment_ou | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pay_mode | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pay_to_supp | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_invoice_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_invoice_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_invoice_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| comments | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tax_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Mat_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Lab_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Misc_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Exch_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_BER_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Salvg_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Base_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Tax_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Chrgs_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Disc_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Total_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| PayRef_ID | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Paymnt_Instrn | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rev_doc_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rev_doc_ou | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rev_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ref_doc_ou | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rev_reason_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rev_remarks | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| hld_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| hld_reason_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| hld_remarks | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| auth_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_comp_basis | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| discount_proportional | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| comp_bp_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| bank_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| lsv_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| comp_acct_in | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| comp_bp_ref | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| comp_bp_acc_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| partid_digits | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| refno_digits | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_acct_in | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_bp_ref | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_bp_acc_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_applicable | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| non_vat_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| doc_level_disc | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_incl | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| retain_init_distbn | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| cap_non_ded_charge | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| average_vat_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_excl_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_incl_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pre_round_off_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rounded_off_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_quotation | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_pay_mode | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Number | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Ou | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_ExpenseType | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_PayMode | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ordering_ou | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_receipt_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ro_receipt_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| originating_ou | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| part_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| serial_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_flag | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| match_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| SRI_WF_DOC_KEY | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| SRI_WF_NEW_STATE | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| DataExp_Flag | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Fw_cov_flag | varchar(20) | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr
Subject Area Table/View Comment Table that contains the info about the document number and document status and the supplier information for each transactions
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Fw_cov_rate | numeric(28,8) | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | varchar(18) | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| status_desc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| suppliername | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| supp_invoice_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| fb_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| pay_priority | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| priority_desc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| non_Vat_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| doc_level_disc | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_incl_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_excl_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| retain_init_distbn | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| cap_non_ded_charge | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_incl | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| exchange_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| onmat_taxkey | varchar(18) | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| onmat_taxkeydesc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| onlab_taxkey | varchar(18) | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| onlab_taxkeydesc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ondoc_taxkey | varchar(18) | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| ondoc_taxkeydesc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Mat_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Lab_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Misc_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Exch_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_BER_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Salvg_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Base_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Tax_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Chrgs_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Disc_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_invoice_hdr_tmp1
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Total_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| BER_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| FacObj_Code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| FacObj_Type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Inv_Quantity | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Item_Code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Item_Description | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Part_LotNum | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Part_SerialNum | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Part_Type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Prop_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Prop_Quantity | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Recpt_Date | datetime | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Recpt_No | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Sale_UOM | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Salvage_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Part_Status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_item_dtl
Subject Area Table/View Comment Table that contains the info about the RepairReceipt’s and billed quantity for each document numbers
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| note_category | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| category_value | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| note_text | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_notes_dtl
Subject Area Table/View Comment Table that containst the notes and comments details for the Document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| term_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NOT NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| posting_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| due_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| due_amount_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| due_percent | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| due_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_comp_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_amount_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_date | datetime | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_percent | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| penalty_percent | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_ref_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_coding_line | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| esr_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_due_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_esr_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_payment_dtl
Subject Area Table/View Comment Table contains the payterm and the due_amount for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name SRI_PRICE_VARIANCE_WF_TMP
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name SRI_PRICE_VARIANCE_WF_TMP
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| invoiceno | sql_variant | NULL | No | No |
Subject Area Table/View Name SRI_PRICE_VARIANCE_WF_TMP
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_date | datetime | NULL | No | No |
Subject Area Table/View Name SRI_PRICE_VARIANCE_WF_TMP
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| current_state | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_roinvoice_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_roinvoice_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| rono | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_roinvoice_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| roou | int | NULL | No | No |
Subject Area Table/View Name sri_roinvoice_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| quantity | bigint | NULL | No | No |
Subject Area Table/View Name sri_roinvoice_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_code | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_version | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NOT NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_var | sql_variant | NOT NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_level | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| taxable_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| cost_center | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| analysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| subanalysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| remarks | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_basis | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl
Subject Area Table/View Comment Table that containt the TCD info for each documents that has TCD attachements
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_on | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| line_no | int | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_var | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_desc | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_level | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| taxable_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_currency | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| usage | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| par_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| cost_center | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| analysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| subanalysis_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| remarks | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modeflag | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_basis | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tax_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_tcd_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_on | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| fb_id | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| asset_class | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| SrcOu | int | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| SrcComponent | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_OU | int | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_No | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Task | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Flag | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Date | datetime | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Curr | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_ProposalNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Stage | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_LineNo | int | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Document_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Ou | int | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Number | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_CompID | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Task | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Flag | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_ProposalNo | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Stage | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Curr | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| Refoct_LineNo | int | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_updproposal_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| RefDoc_Status | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NOT NULL | Yes | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_line_no | int | NOT NULL | Yes | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| doc_line_no | int | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_var | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_category | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_class | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_var | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| inp_vat_deduct_per | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_item_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| non_vat_item_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_dist_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_level_disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| dist_disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| corr_vat_tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| corr_vat_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| account_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl
Subject Area Table/View Comment Table contains the VAT details for each document number
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| timestamp | int | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_ou | int | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tran_no | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_line_no | int | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| doc_line_no | int | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_type | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| account_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_code | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_tcd_var | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_category | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_class | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| tcd_var | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_rate | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| inp_vat_deduct_per | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_item_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| non_vat_item_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_dist_charge | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| item_level_disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| dist_disc_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| corr_vat_tran_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| vat_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| corr_vat_base_amount | bigint | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createdby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| createddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifiedby | sql_variant | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| modifieddate | datetime | NULL | No | No |
Subject Area Table/View Name sri_vat_dtl_tmp
| Subject Area Table/View Column Name | Subject Area Table/View Column Datatype | Subject Area Table/View Column Null Option | Subject Area Table/View Column Is PK | Subject Area Table/View Column Is FK |
|---|---|---|---|---|
| guid | sql_variant | NULL | No | No |