Table Owner | Table Name | Table Comment | Table Column Name | Table Column Datatype | Table Column Comment | Table Column Is PK | Table Column Is FK |
---|---|---|---|---|---|---|---|
dbo | stn_acct_info_dtl | ou_id | sql_variant | Organization Unit Id | Yes | No | |
  |   | company_code |   | Company Code |   |   | |
  |   | tran_no |   | Transaction Number |   |   | |
  |   | tran_type |   | Transaction Type |   |   | |
  |   | account_code |   | Account Code |   |   | |
  |   | drcr_flag |   | Debit Credit Flag |   |   | |
  |   | account_type |   | Account Type | No |   | |
  |   | tran_date | datetime | Transaction Date |   |   | |
  |   | fin_post_date |   | Finance Posting Date |   |   | |
  |   | currency_code | sql_variant | Currency Code |   |   | |
  |   | cost_center |   | Cost Center |   |   | |
  |   | tran_amount | bigint | Transaction Amount |   |   | |
  |   | fb_id | sql_variant | Finance Book Id |   |   | |
  |   | analysis_code |   | Analysis Code |   |   | |
  |   | subanalysis_code |   | Subanalysis Code |   |   | |
  |   | basecur_erate | bigint | Base Currency Exchange Rate |   |   | |
  |   | base_amount |   | Base Amount |   |   | |
  |   | pbcur_erate |   | Parallel Base Currency Exchange Rate |   |   | |
  |   | par_base_amt |   | Parallel Base Amount |   |   | |
  |   | fin_post_status | sql_variant | Finance Posting Status |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | acct_line_no | int | Account Line Number |   |   | |
  |   | bu_id | sql_variant | Business Unit Id |   |   | |
  |   | transfer_docno |   | Transfer Document Number |   |   | |
  |   | supplier_code |   | Supplier Code |   |   | |
  | stn_acctlnk_tmp | guid |   | Guid | Yes |   | |
  |   | document_no |   | Document Number |   |   | |
  | stn_attach_notes | trans_credit_note |   | Transaction Credit Note |   |   | |
  |   | trans_ouid | int | Transaction Organization Unit Id |   |   | |
  |   | notesfor | sql_variant | Notes For | No |   | |
  |   | notes |   | Notes |   |   | |
  | stn_comptot_tmp | guid |   | Guid |   |   | |
  |   | doc_no |   | Document Number |   |   | |
  |   | doc_ou | int | Document Organization Unit |   |   | |
  |   | doc_type | sql_variant | Document Type |   |   | |
  |   | doc_date | datetime | Document Date |   |   | |
  |   | supp_area | int | Supplier Area |   |   | |
  |   | doc_amount | bigint | Document Amount |   |   | |
  |   | exchange_rate |   | Exchange Rate |   |   | |
  |   | outstanding_amount |   | Outstanding Amount |   |   | |
  |   | total_amt |   | Total Amount |   |   | |
  | stn_credit_note_dtl | ou_id | int | Organization Unit Id | Yes |   | |
  |   | trns_credit_note | sql_variant | Transfer Credit Notes |   |   | |
  |   | tran_type |   | Transaction Type |   |   | |
  |   | timestamp | int | Time Stamp | No |   | |
  |   | transfer_docno | sql_variant | Transfer Document Number |   |   | |
  |   | notype_no |   | Numbering Type |   |   | |
  |   | tran_date | datetime | Transaction Date |   |   | |
  |   | supplier_code | sql_variant | Supplier Code |   |   | |
  |   | currency_code |   | Currency Code |   |   | |
  |   | account_code |   | Account Code |   |   | |
  |   | fb_id |   | Finance Book Id |   |   | |
  |   | tran_amount | bigint | Transaction Amount |   |   | |
  |   | cost_center | sql_variant | Cost Center |   |   | |
  |   | analysis_code |   | Analysis Code |   |   | |
  |   | subanalysis_code |   | Subanalysis Code |   |   | |
  |   | exchange_rate | bigint | Exchange Rate |   |   | |
  |   | pbcur_erate | sql_variant | Parallel Base Currency Exchange Rate |   |   | |
  |   | transferred_amt | bigint | Transferred Amount |   |   | |
  |   | reason_code | sql_variant | Reason Code |   |   | |
  |   | comments |   | Comments |   |   | |
  |   | ref_doc_no |   | Reference Doument Number |   |   | |
  |   | status |   | Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft |   |   | |
  |   | crosscur_erate | bigint | Cross Currency Exchange Rate |   |   | |
  |   | base_amount |   | Base Amount |   |   | |
  |   | par_base_amt |   | Parallel Base Amount |   |   | |
  |   | batch_id | sql_variant | Batch Id |   |   | |
  |   | createdby |   | Created By |   |   | |
  |   | createddate | datetime | Created Date |   |   | |
  |   | modifiedby | sql_variant | Modified By |   |   | |
  |   | modifieddate | datetime | Modified Date |   |   | |
  | stn_debit_note_dtl | ou_id | int | Organization  Unit Id | Yes |   | |
  |   | trns_debit_note | sql_variant | Transfer Debit Notes |   |   | |
  |   | tran_type |   | Transaction Type |   |   | |
  |   | timestamp | int | Time Stamp | No |   | |
  |   | notype_no | sql_variant | Numbering Type |   |   | |
  |   | transfer_docno |   | Transfer Document Number |   |   | |
  |   | tran_date | datetime | Transaction Date |   |   | |
  |   | supplier_code | sql_variant | Supplier Code |   |   | |
  |   | currency_code |   | Currency Code |   |   | |
  |   | account_code |   | Account Code |   |   | |
  |   | fb_id |   | Finance Book Id |   |   | |
  |   | tran_amount | bigint | Transaction Amount |   |   | |
  |   | cost_center | sql_variant | Cost Center |   |   | |
  |   | analysis_code |   | Analysis Code |   |   | |
  |   | subanalysis_code |   | Subanalysis Code |   |   | |
  |   | exchange_rate | bigint | Exchange Rate |   |   | |
  |   | pbcur_erate |   | Parallel Base Currency Exchange Rate |   |   | |
  |   | transferred_amt |   | Transferred Amount |   |   | |
  |   | reason_code | sql_variant | Reason Code |   |   | |
  |   | comments |   | Comments |   |   | |
  |   | ref_doc_no |   | Reference Document Number |   |   | |
  |   | status |   | Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft |   |   | |
  |   | crosscur_erate | bigint | Cross Currency Exchange Rate |   |   | |
  |   | base_amount |   | Base Amount |   |   | |
  |   | par_base_amt |   | Parallel Base Amount |   |   | |
  |   | batch_id | sql_variant | Batch Id |   |   | |
  |   | createdby |   | Created By |   |   | |
  |   | createddate | datetime | Created Date |   |   | |
  |   | modifiedby | sql_variant | Modified By |   |   | |
  |   | modifieddate | datetime | Modified Date |   |   | |
  | stn_doc_dtl | ou_id | int | Organization Unit Id | Yes |   | |
  |   | trns_debit_note | sql_variant | Transfer Debit Note |   |   | |
  |   | tran_type |   | Transaction Type |   |   | |
  |   | dr_doc_no |   | Debit Document Number |   |   | |
  |   | ref_tran_type |   | Reference Transaction Type |   |   | |
  |   | dr_doc_ou | int | Debit Document Organization Unit |   |   | |
  |   | dr_doc_type | sql_variant | Debit Document type | No |   | |
  |   | au_doc_date | datetime | Authorized Document Date |   |   | |
  |   | au_supp_area | int | Authorized Supplier Area |   |   | |
  |   | au_document_amount | bigint | Authorized Document Amount |   |   | |
  |   | transfer_status | sql_variant | Transfer Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft |   |   | |
  |   | exchange_rate | bigint | Exechange Rate |   |   | |
  |   | batch_id | sql_variant | Batch Id |   |   | |
  | stn_doc_dtl_tmp | guid |   | Guid | Yes |   | |
  |   | ou_id | int | Organization Unit Id |   |   | |
  |   | doc_no | sql_variant | Document Number |   |   | |
  |   | doc_ou | int | Document Organization Unit |   |   | |
  |   | doc_type | sql_variant | Document Type |   |   | |
  |   | doc_date | datetime | Document Date | No |   | |
  |   | supp_area | int | Supplier Area |   |   | |
  |   | doc_amount | bigint | Document Amount |   |   | |
  |   | exchange_rate |   | Exchange Rate |   |   | |
  |   | tran_no | sql_variant | Transaction Number |   |   | |
  |   | tran_ou | int | Transaction Organization Unit |   |   | |
  |   | tran_date | sql_variant | Transaction Date |   |   | |
  |   | supp_ou | int | Supplier Organization Unit |   |   | |
  |   | tran_type | sql_variant | Transaction Type |   |   | |
  |   | drcr_flag |   | Debit Credit Flag |   |   | |
  | stn_doc_rpt_tmp | doctype |   | Document Type |   |   | |
  |   | docnumber |   | Document Number |   |   | |
  |   | docdate | datetime | Document Date |   |   | |
  |   | supplierregister | sql_variant | Supplier Register |   |   | |
  |   | amount | bigint | Amount |   |   | |
  |   | tran_type | sql_variant | Transaction Type |   |   | |
  |   | ou_id | int | Organization Unit Id |   |   | |
  |   | trns_credit_note | sql_variant | Transfer Credit Note |   |   | |
  |   | term_no |   | Term Number |   |   | |
  |   | due_date | datetime | Due Date |   |   | |
  |   | due_amount | bigint | Due Amount |   |   | |
  |   | discount_date | datetime | Discount Date |   |   | |
  |   | disc_percent | bigint | Discount Percentage |   |   | |
  |   | discount |   | Discount |   |   | |
  |   | penalty_percent |   | Penalyty Percentage |   |   | |
  |   | guid | sql_variant | Guid |   |   | |
  |   | pay_term |   | Pay Term |   |   | |
  |   | dummy_var |   | Dummy |   |   | |
  | stn_payment_dtl | tran_type |   | Transaction Type | Yes |   | |
  |   | ou_id | int | Organization Unit Id |   |   | |
  |   | trns_credit_note | sql_variant | Transfers Credit Notes |   |   | |
  |   | pay_term |   | Pay Term |   |   | |
  |   | term_no |   | Term Number |   |   | |
  |   | due_date | datetime | Due Date | No |   | |
  |   | due_amt_type | sql_variant | Due Amount Type |   |   | |
  |   | due_percent | bigint | Due Percentage |   |   | |
  |   | due_amount |   | Due Amount |   |   | |
  |   | disc_amount_type | sql_variant | Discount Amount Type |   |   | |
  |   | dis_comp_amt | bigint | Discount Computation Amount |   |   | |
  |   | discount_date | datetime | Discount Date |   |   | |
  |   | disc_percent | bigint | Discount Percentage |   |   | |
  |   | discount |   | Discount |   |   | |
  |   | penalty_percent |   | Penalty Percentage |   |   | |
  |   | esr_ref_no | sql_variant | ESR Reference Number |   |   | |
  |   | esr_amount | bigint | ESR Amount |   |   | |
  |   | esr_code_line | sql_variant | ESR Code Line |   |   | |
  | stn_payment_hdr | ou_id | int | Organizarion Unit Id | Yes |   | |
  |   | trns_credit_note | sql_variant | Transfer Credit Notes |   |   | |
  |   | pay_term |   | Pay Term |   |   | |
  |   | tran_type |   | Transaction Type |   |   | |
  |   | status |   | Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft | No |   | |
  |   | disc_computation |   | Discount Computation |   |   | |
  |   | elec_payment |   | Electronic Payment |   |   | |
  |   | payment_method |   | Payment Method |   |   | |
  |   | payment_route |   | Payment Route |   |   | |
  |   | pay_mode |   | Pay Mode |   |   | |
  |   | esr_part_id |   | ESR Part Id |   |   | |
  |   | partid_digits | int | Part Id Digits |   |   | |
  |   | esr_ref_no | sql_variant | ESR Reference Number |   |   | |
  |   | lsv_bank_code |   | LSV Bank Code |   |   | |
  |   | lsv_contract_id |   | LSV Contract Id |   |   | |
  |   | lsv_contract_ref |   | LSV Contract Reference |   |   | |
  |   | comp_acct_in |   | Component Acctouning Information |   |   | |
  |   | comp_bnkptt_acct |   | Component Bank / PTT Account |   |   | |
  |   | comp_bnkptt_ref |   | Component Bank / PTT Reference |   |   | |
  |   | supp_acct_in |   | Supplier Account Information |   |   | |
  |   | supp_bnkptt_acct |   | Supplier Bank / PTT Account |   |   | |
  |   | supp_bnkptt_ref |   | Supplier Bank/Ptt Reference |   |   | |
  |   | ps_pi_flag |   | Flag |   |   | |
  | stn_payment_rpt_tmp | tran_type |   | Transaction Type |   |   | |
  |   | ou_id | int | Organization Unit Id |   |   | |
  |   | trns_credit_note | sql_variant | Transfer Credit Note |   |   | |
  |   | term_no |   | Term Number |   |   | |
  |   | due_date | datetime | Due Date |   |   | |
  |   | due_amount | bigint | Due Amount |   |   | |
  |   | discount_date | datetime | Discount Date |   |   | |
  |   | disc_percent | bigint | Discount Percentage |   |   | |
  |   | discount |   | Discount |   |   | |
  |   | penalty_percent |   | Penalty Percentage |   |   | |
  |   | dummy_var | sql_variant | Dummy |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | dummy_var1 |   | Dummy |   |   | |
  |   | payterm |   | Pay Term |   |   | |
  |   | pay_term |   | Pay Term. |   |   | |
  | stn_stdnotes_tmp | std_notes_id |   | Standard Notes Id | Yes |   | |
  |   | std_notes_desc |   | Standard Notes Description |   |   | |
  |   | notes |   | Notes | No |   | |
  |   | guid |   | Guid |   |   | |
  | stn_transfer_bal_hdr | ou_id | int | Organization Unit Id | Yes |   | |
  |   | transfer_docno | sql_variant | Transfer Document Number |   |   | |
  |   | transfer_date | datetime | Transfer Date | No |   | |
  |   | transfer_bal_in | sql_variant | Transfer Balance Information |   |   | |
  |   | transferor |   | Transferor |   |   | |
  |   | auto_adjust |   | Auto Adjust |   |   | |
  |   | transferee |   | Transferee |   |   | |
  |   | transferor_docno |   | Transferor Document Number |   |   | |
  |   | transferor_doctype |   | Transferor Document Type |   |   | |
  |   | transferee_docno |   | Transferee Document Number |   |   | |
  |   | transferee_doctype |   | Transferee Document Type |   |   | |
  |   | au_account_balance | bigint | Authorized Account Balance |   |   | |
  |   | status | sql_variant | Status.Values F-Fresh,A-Authorised,H-Hold,D-Draft |   |   | |
  |   | au_tran_amount | bigint | Authorized Transaction Amount |   |   | |
  |   | au_account_code | sql_variant | Authorized Account Code |   |   | |
  |   | batch_id |   | Batch Id |   |   |