Table Name/Column Name

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