REPSPM

Table Owner Table Name Table Comment Table Column Name Table Column Datatype Table Column Comment Table Column Is PK Table Column Is FK
dbo ard_supplier_account_rpt_tmp company_code sql_variant Company Code No No
    supplier_group   Supplier Group    
    fb_id   Finance Book Id    
    currency_code   Currency Code    
    account_code   Account Code    
    supp_control_acct_type   Supplier Control Account Type    
    supplier_type   Supplier Type    
    guid   Guid    
  pm_sst_rpt_tmp address   Address    
    amount bigint Amount    
    billingamt   Billing Amount    
    buid sql_variant Business Unit Id    
    calyear   Calendar Year    
    closingbalance bigint Closing Balance    
    CM_DocId sql_variant Document Id    
    companycode   Company Code    
    contactname   Contact Name    
    companycontactname   Company Contact Name    
    companyaddress1   Company Address 1    
    companyaddress2   Company Address 2    
    companyaddress3   Company Address 3    
    companyaddress4   Company Address 4    
    companyaddress5   Company Address 5    
    companyaddress6   Company Address 6    
    companyaddress7   Company Address 7    
    contactperson   Contact Person    
    currency_code   Currecny Code    
    currency_ml   Currency Multiple Line    
    dateoption   Date Option    
    depositamt bigint Deposit Amount    
    desc255 sql_variant Description 255    
    desc255ml   Description 255 Multiple Line    
    docdate datetime Document Date    
    documentno sql_variant Document Number    
    datefrom datetime Date From    
    dateto   Date To    
    duedate   Due Date    
    financialperiod sql_variant Financial Period    
    financialyear   Financial Year    
    fromsupplier   From Supplier    
    finmonth   Financial Month    
    grandtotal bigint Grand Total    
    instrumentdate datetime Instrument Date    
    instrumentnumber sql_variant Instrument Number    
    language   Language    
    mltdescription   Multiple Line Description    
    narration   Narration    
    openingbalance bigint Opening Balance    
    outstandingamount   Outstanding Amount    
    paymentamt   Payment Amount    
    phonenumber sql_variant Phone Number    
    purpose   Purpose    
    reporttype   Report Type    
    status   Status    
    suppliercodeto   Supplier Code To    
    supplierfrom   Supplier Code From    
    suppliergroup   Supplier Group    
    suppliergrpfrom   Supplier Group From    
    suppliergrpto   Supplier Group To    
    suppliername   Supplier Name    
    tosupplier   To Supplier    
    transaction1   Transaction 1    
    transactiontype   Transaction Type    
    transactiontypehdn   Transaction Type Hidden    
    actualamount bigint Actual Amount    
    supplieraddress1 sql_variant Supplier Address 1    
    supplieraddress2   Supplier Address 2    
    supplieraddress3   Supplier Address 3    
    supplieraddress4   Supplier Address 4    
    supplieraddress5   Supplier Address 5    
    supplieraddress6   Supplier Address 6    
    supplieraddress7   Supplier Address 7    
    supplieraddress8   Supplier Address 8    
    advamt bigint Advance Amount    
    companyname sql_variant Company Name    
    dateml datetime Date Multiple Line    
    supdocrefno sql_variant Supplier Document Reference Number    
    totoutstandingamt bigint Total Outstanding Amount    
    unadjppiamt   Unadjusted Pre-payment Invoice Amount    
    guid sql_variant Guid    
  rep_out_temp ou_id int Organization Unit Id    
    tran_type sql_variant Transaction Type    
    age int Age    
    guid sql_variant Guid    
    tran_no   Transaction Number    
    tran_date datetime Transaction Date    
    supplier_code sql_variant Supplier Code    
    tran_amount bigint Transaction Amount    
    base_amount   Base Amount    
    parbase_amount   Parallel Base Amount    
    tran_currency sql_variant Transaction Currency    
    bucket   Bucket    
    bucket_desc   Bucket Description    
  rep_sst_process To store supplier statement details  for reporting purposes guid   Guid    
      document_grp_ou int Document Group Organization Unit    
      document_grp_no sql_variant Document Group Number    
      document_grp_type   Document Group Type    
      document_key   Document Key    
  reports_ageing_bucket_dtl To Store information about supplier ageing bucket details  for reporting purposes ou_id int Organization Unit Id    
      bucket_no   Bucket Number    
      bucket_from   Bucket From    
      bucket_to   Bucket To    
      flag sql_variant Flag    
  repspm_age_fmt_tmp guid   Guid    
    asondate datetime As On Date    
    suppliername sql_variant Supplier Name    
    supplier_code   Supplier Code    
    daysfrom int Days From    
    daysto   Days To    
    tran_amount bigint Transaction Amount    
    flag sql_variant Flag    
    fb_id   Finance Book Id    
    currency_code   Currency Code    
  repspm_age_output_tmp guid   Guid    
    bu   Business Unit    
    companycode   Company Code    
    companyname   Company  Name    
    crtdatmlt   Credit document amount    
    fb   Finance Book    
    currencycodeml   Currency Code Multiple    
    supplier_code   Supplier Code    
    suppliername   Supplier Name    
    asondate datetime As On Date    
    cm_docid sql_variant Document Id    
    currencyoption   Currency Option    
    amount bigint Amount    
    amount1   Amount 1    
    amountconsidered   Amount Considered    
    amountdue   Amount Due    
    amountfrom   Amount From    
    amountin   Amount Information    
    amountml   Amount Multiple    
    amountto   Amount To    
    amountto1   Amount To 1    
    desc4 sql_variant Description 4    
    desc1   Description 1    
    desc2   Description 2    
    desc255   Description 255    
    desc3   Description 3    
    description2   Description 2    
    description3   Description 3    
    descriptionfrom   Description From    
    descriptionhdr   Description Header    
    descriptionto   Description To    
    includeprepayments   Include Prepayments    
    language   Language    
    suppliercodeto   Supplier Code    
    supplierfrom   Supplier From    
    suppliergroup   Supplier Group    
    totalpayamount bigint Total Payamount    
  repspm_calendaryear_tmp ma_guid sql_variant Management Account Guid    
    ma_year varchar(10) Management Account Year    
    ma_month   Management Account Month    
    ma_monthno int Management Account Month To    
  repspm_invoice_tmp guid sql_variant Guid    
    invoice_type   Invoice Type    
    invoice_ou   Invoice Organization Unit    
    invoice_no   Invoice Number    
    termno   Term Number    
    receipt_type   Receipt Type    
    receipt_ou   Receipt Organization Unit    
    receipt_no   Receipt Number    
    adj_tran_type   Adjustment Transaction Type    
    adj_ou   Adjustment Organization Unit    
    adj_voucher_no   Adjustment Voucher Number    
    adj_fb   Adjustment Finance Book    
    adj_voucher_date datetime Adjustment Voucher Date    
    adj_currency sql_variant Adjustment Currency    
    adjust_amount bigint Adjustment Amount    
    discount   Discount    
    charges   Charges    
  repspm_pno_rpt_tmp companycode sql_variant Company Code    
    companyname   Company Name    
    companyaddress1   Company Address 1    
    companyaddress2   Company Address 2    
    companyaddress3   Company Address 3    
    companyaddress4   Company Address 4    
    companyaddress5   Company Address 5    
    companyaddress6   Company Address 6    
    companyaddress7   Company Address 7    
    suppliercode   Supplier Code    
    suppliername   Supplier Name    
    supplieradd1   Supplier Address 1    
    supplieradd2   Supplier Address 2    
    supplieradd3   Supplier Address 3    
    supplieradd4   Supplier Address 4    
    supplieradd5   Supplier Address 5    
    supplieradd6   Supplier Address 6    
    supplieradd7   Supplier Address 7    
    supplieradd8   Supplier Address 8    
    supplieradd9   Supplier Address 9    
    notenumber   Note Number    
    supp_notenumber   Supplier Note Number    
    notedate datetime Note Date    
    supp_notedate   Supplier Note Date    
    status sql_variant Status    
    currency_code   Currency Code    
    tranamount bigint Transaction Amount    
    supp_tranamount   Supplier Transaction Amount    
    comments sql_variant Comments    
    accountcode   Account Code    
    accountdesc   Account Description    
    refamount bigint Reference Amount    
    ref_tranamount   Reference Transaction Amount    
    pay_term sql_variant Pay Term    
    pay_method   Pay Method    
    anchor_date datetime Anchor Date    
    elec_pay sql_variant Electronic Pay    
    pay_mode   Pay Mode    
    pay_priority   Pay Priority    
    payment_ou int Payment Organization    
    refdocno sql_variant Reference Document Number    
    refdocdate datetime Reference Document Date    
    ref_doc_type sql_variant Reference Document Type    
    cost_center   Cost Center    
    analysis_code   Analysis Code    
    subanalysis_code   Subanalysis Code    
    createdby   Created By    
    createddate datetime Created Date    
    modifiedby sql_variant Modified By    
    modifieddate datetime Modified Date    
    duedate   Due Date    
    dueamount bigint Due Amount    
    discountdate datetime Discount Date    
    discountamount bigint Discount Amount    
    penalty   Penalty    
    place sql_variant Place    
    itemcode   Item Code    
    itemdesc   Item Description    
    UOM   Unit Of Measurement    
    quantity bigint Quantity    
    rate   Rate    
    debitcredit sql_variant Debit Credit    
    fbid   Finance Book Id    
    exchange_rate bigint Exchange Rate    
    Notetype sql_variant Note Type    
    ou_desc   Organization Unit Description    
    flag   Flag    
    guid   Guid    
  repspm_pno_tran_rpt_tmp tran_ou   Transaction Organization Unit    
    tran_type   Transaction Type    
    tran_no   Transaction Number    
    supplier_code   Supplier Code    
    Doc_type   Document Type    
    Account_no   Account Number    
    Account_type   Account Type    
    Amount bigint Amount    
    tra_doc_no sql_variant Transaction Document Number    
    fb   Finance Book    
    guid   Guid    
    tran_date datetime Transaction Date    
    Tot_amount bigint Total Amount    
    drcr_flag sql_variant Debit Credit Flag    
    status   Status    
  repspm_prninv_tmp guid   Guid    
    tran_type   Transaciton Type    
    tran_ou int Transaciton Organization Unit    
    bu_id sql_variant Business Unit Id    
    company_code   Company Code    
    tran_no   Transaction Number    
    tran_date datetime Transaction Date    
    tran_status sql_variant Transaction Status    
    supp_invoice_no   Supplier Invoice Number    
    supp_code   Supplier Code    
    supp_invoice_date datetime Supplier Invoice Date    
    supp_invoice_amount bigint Supplier Invoice Amount    
    fb_id sql_variant Finance Book Id    
    tran_currency   Transaction Currency    
    tran_amount bigint Transaction Amount    
    exchange_rate   Exchange Rate    
    item_tcd_code sql_variant Item Tax Charge Discount Code    
    item_tcd_var   Item Tax Charge Discount Variant    
    uom   Unit Of Measurement    
    item_qty bigint Item Quantity    
    usage sql_variant Usage    
    item_rate bigint Item Rate    
    rate_per   Rate Per    
    item_amount   Item Amount    
    tcdcode sql_variant Tax Charge Discount Code    
    tcdvar   Tax Charge Discount Variant    
    ref_doc_no   Reference Document Number    
    rev_doc_no   Reversal Document Number    
    rev_date datetime Reversal Date    
    rev_reason_code sql_variant Reversal Reason Code    
    rev_remarks   Reversal Remarks    
    hld_reason_code   Hold Reason Code    
    hld_remarks   Hold Remarks    
    proposal_no   Proposal Number    
    tcddesc   Tax Charge Discount Description    
    line_no int Line Number    
    pay_term sql_variant Pay Term    
    pay_method   Pay Method    
    anchor_date datetime Anchor Date    
    elec_pay sql_variant Electronic Pay    
    pay_mode   Pay Mode    
    pay_priority   Pay Priority    
    comments   Comments    
    cost_center   Cost Center    
    analysis_code   Analysis Code    
    subanalysis_code   Subanalysis Code    
    due_date datetime Due Date    
    due_amount bigint Due Amount    
    disc_date datetime Discount Date    
    disc_percent bigint Discount Percentage    
    disc_amount   Discount Amount    
    penalty_percent   Penalty Percentage    
    suppliername sql_variant Supplier Name    
    createdby   Created By    
    createddate datetime Created Date    
    modifiedby sql_variant Modified By    
    modifieddate datetime Modified Date    
    expense sql_variant Expense    
    tran_status_desc   Transaction Status Description    
    po_no   Purchase Order Number    
    po_ou int Purchase Order Organization Unit    
    item_type sql_variant Item Type    
    tcd_level   Tax Charge Discount Level    
    CompanyName   Company Name    
    company_address1   Company Address 1    
    company_address2   Company Address 2    
    company_address3   Company Address 3    
    company_address4   Company Address 4    
    company_address5   Company Address 5    
    company_address6   Company Address 6    
    company_address7   Company Address 7    
    supplier_address1   Supplier Address 1    
    supplier_address2   Supplier Address 2    
    supplier_address3   Supplier Address 3    
    supplier_address4   Supplier Address 4    
    supplier_address5   Supplier Address 5    
    supplier_address6   Supplier Address 6    
    supplier_address7   Supplier Address 7    
    supplier_address8   Supplier Address 8    
    supplier_address9   Supplier Address 9    
    ou_desc   Organization Unit Description    
    sobitcd_value bigint Tax Charge Discount Value of supplier order based invoice    
    vatamount   Value Added Tax Amount    
    flag sql_variant Flag    
    itemdesc   Item Description    
    vatdesc   Value Added Tax Description    
  repspm_pvo_rpt_snp_tmp voucher_no   Voucher Number    
    fb_id   Finance Book Id    
    payee_name   Payee Name    
    pay_date datetime Pay Date    
    pay_currency sql_variant Pay Currency    
    exchange_rate bigint Exchange Rate    
    pay_amount   Pay Amount    
    pay_method sql_variant Pay Method    
    payment_route   Payment Route    
    pay_mode   Pay Mode    
    bank_cash_code   Bank Cash Code    
    relpay_ou int Release Payment Organization Unit    
    priority sql_variant Priority    
    hr_reason_code   HR Reason Code    
    hr_remarks   HR Remarks    
    reversal_reason_code   Reversal Reason Code    
    reversal_date datetime Reversal Date    
    reversal_remarks sql_variant Reversal Remarks    
    address1   Address 1    
    address2   Address 2    
    address3   Address 3    
    city   City    
    state   State    
    country   Country    
    zip_code   Zip Code    
    contact   Contact    
    url   Universal Resource Locator    
    mail_stop   Mail Stop    
    pager_no   Pager Number    
    email_id   Email Id    
    telex   Telex    
    phone_no   Phone Number    
    mobile_no   Mobile Number    
    fax_no   Fax Number    
    cap_charge   Capitalization Charge    
    voucher_status   Voucher Status    
    guid   Guid    
  repspm_pvo_rpt_tmp voucher_no   Voucher Number    
    request_date datetime Request Date    
    fb_id sql_variant Finance Book Id    
    pay_date datetime Pay Date    
    supp_code sql_variant Supplier Code    
    payment_route   Payment Route    
    pay_mode   Pay Mode    
    pay_currency   Pay Currency    
    pay_amount bigint Pay Amount    
    doc_type sql_variant Document Type    
    ref_doc_no   Reference Document Number    
    ref_pay_amount bigint Reference Pay Amount    
    status sql_variant Status    
    due_date datetime Due Date    
    due_amt bigint Due Amount    
    pay_batch_no sql_variant Pay Batch Number    
    supp_name   Supplier Name    
    cr_doc_type   Credit Document Type    
    dr_doc_type   Debit Document Type    
    cr_doc_no   Credit Document Numebr    
    dr_doc_no   Debit Document Number    
    cr_unadj_amt bigint Credit Unadjustment Amount    
    dr_unadj_amt   Debit Unadjustment Amount    
    cr_doc_cur sql_variant Credit Document Currency    
    dr_doc_cur   Debit Document Currency    
    cr_erate bigint Credit Exchange Rate    
    dr_doc_amt   Debit Document Amount    
    cr_adj_amt   Credit Adjustment Amount    
    dr_adj_amt   Debit Adjustment Amount    
    discount   Discount    
    disc_date datetime Discount date    
    dr_doc_date   Debit Document Date    
    cr_fbid sql_variant Credit Finance Book Id    
    dr_fbid   Debit Finance Book Id    
    guid   Guid    
  repspm_quick_code_met To store system defined information  for reporting purposes component_id   Component Id Yes  
      parameter_type   Parameter Type    
      parameter_category   Parameter Category    
      parameter_code   Parameter Code    
      timestamp int Time Stamp No  
      parameter_text sql_variant Parameter Text    
      language_id int Language Id    
      extension_flag sql_variant Extension Flag    
      createdby   Created By    
      createddate datetime Created Date    
      modifiedby sql_variant Modified By    
      modifieddate datetime Modified Date    
  repspm_sba_rpt_result_tmp guid sql_variant Guid    
    tran_type   Transaction Type    
    tran_ou int Transaction Organization Unit    
    tran_no sql_variant Transaction Number    
    sequence_no int Sequence Number    
    tran_date datetime Transaction Date    
    component_id sql_variant Component Id    
    lo_id   Logistics Organization Id    
    company_code   Company Code    
    company_name   Company Name    
    bu_id   Business Unit Id    
    fb_id   Finance Book Id    
    supp_ou int Supplier Organization Unit    
    supplier_code sql_variant Supplier Code    
    supp_name   Supplier Name    
    account_code   Account Code    
    account_desc   Account Description    
    ctrl_acct_type   Control Account Type    
    acct_currency   Account Currency    
    due_date datetime Due Date    
    tran_due_amount bigint Transaction Due Amount    
    base_due_amount   Base Due Amount    
    par_due_amount   Parallel Due Amount    
    cur_opt_due_amount   Due amount    
    age int Age    
    bucket sql_variant Bucket    
    bucket_desc   Bucket Description    
  repspm_sdd_ml_temp guid   Guid    
    trans_desc   Transaction Description    
    trans_type   Transaction Type    
    docno_from   Document Number From    
    docno_to   Document Number To    
    docamt_from bigint Document Amount From    
    docamt_to   Document Amount To    
    docstat_desc sql_variant Document Status Description    
    doc_status   Document Status    
    disamt_from bigint Discount Amount From    
    disamt_to   Discount Amount To    
    penalty_from   Penalty From    
    penalty_to   Penalty To    
    date_criteria sql_variant Date Criteria    
    daysfrom int Days From    
    daysto   Days To    
    date_from datetime Date From    
    date_to   Date To    
    due_date   Due Date    
    ou_id int Organization Unit    
    inc_no   Increased Number    
  repspm_ssl_rpt_result_tmp guid sql_variant Guid    
    tran_ou int Transaction Organization Unit    
    tran_type sql_variant Transaction Type    
    tran_no   Transaction Number    
    tran_date datetime Transaction Date    
    component_id sql_variant Component Id    
    lo_id   Logistics Organization Id    
    company_code   Company Code    
    bu_id   Business Unit Id    
    fb_id   Finance Book Id    
    supp_ou int Supplier Organization Unit    
    supplier_code sql_variant Supplier Code    
    supp_name   Supplier Name    
    supp_inv_no   Supplier Invoice Number    
    pay_term   Pay Term    
    payterm_version int Pay Term Version    
    doc_status sql_variant Document Status    
    reversed_docno   Reversed Document Number    
    reversal_date datetime Reversal Date    
    bank_code sql_variant Bank Code    
    checkseries_no   Check Series Number    
    check_no   Check Number    
    paid_status   Paid Status    
    vat_applicable   Value Added Tax Applicable    
    discount_proportional   Discount Proportional    
    discount_amount bigint Discount Amount    
    discount_availed   Discount Availed    
    penalty_amount   Penalty Amount    
    reversed_docou int Reversed Document Organization Unit    
    bankcashcode sql_variant Bank Cash Code    
    line_no int Line Number    
    account_code sql_variant Account Code    
    drcr_flag   Debit Credit Flag    
    ctrl_acct_type   Control Account Type    
    auto_post_acct_type   Auto Posted Account Type    
    tran_currency   Transaction Currency    
    acct_currency   Account Currency    
    tran_amount_acc_cur bigint Transaction Amount Account Currency    
    tran_amount_acc_cur_cr   Transaction Amount Account Currency Credit    
    exchange_rate   Exchange Rate    
    base_amount   Base Amount    
    base_amount_cr   Base Amount Credit    
    par_exchange_rate   Parallel Exchange Rate    
    par_base_amount   Parallel Base Amount    
    par_base_amount_cr   Parallel Base Amount Credit    
    narration sql_variant Narration    
    ref_doc_ou int Reference Document Organization Unit    
    ref_doc_fb_id sql_variant Reference Document Finance Book Id    
    ref_doc_type   Reference Document Type    
    ref_doc_no   Reference Document Number    
    auth_date datetime Authorized Date    
    posting_date   Posting Date    
    posting_status sql_variant Posting Status    
    analysis_code   Analysis Code    
    subanalysis_code   Subanalysis Code    
    cost_center   Cost Center    
    supp_control_acct_type   Supplier Control Account Type    
    supplier_type   Supplier Type    
    flag_op   Flag    
    debit_accnt_code   Debit Account Code    
    debit_accnt_desc   Debit Account Description    
    cur_option_dr_amt bigint Currency Option Debit Amount    
    cur_option_cr_amt   Currency Option Credit Amount    
    company_name sql_variant Company Name    
    account_desc   Account Description    
    short_desc   Short Description    
  repspm_ssl_rpt_tmp accountcode   Account Code    
    accountdescription   Account Description    
    bu   Business Unit    
    calyear   Calendar Year    
    closingbalance bigint Closing Balance    
    cm_docid sql_variant Document Id    
    companycode   Company Code    
    companyname   Company Name    
    controlaccounttype   Control Account Type    
    credittotal bigint Credit Total    
    crtdatmlt sql_variant Credit Amount    
    currencyoption   Currency Option    
    currency_code   Currency Code    
    currency_codeml   Currency Code Multiple Line    
    datefrom datetime Date From    
    dateoption sql_variant Date Option    
    dateto datetime Date To    
    debittotal bigint Debit Total    
    desc255 sql_variant Description255    
    documentdate datetime Document Date    
    documentno sql_variant Document Number    
    fb   Finance Book    
    financialperiod   Financial Period    
    financialyear   Financial Year    
    finmonth   Financial Month    
    opbal bigint Opening Balance    
    reportingbasis sql_variant Reporting Basis    
    reporttype   Report Type    
    supcode   Supplier Code    
    supplierfrom   Supplier From    
    suppliergroup   Supplier Group    
    suppliergroupmlt   Supplier Group Mutiple line    
    suppliername   Supplier Name    
    supplierto   Supplier To    
    transactiontype   Transaction Type    
    guid   Guid    
  repspm_sst_rpt_result_tmp          
    tran_ou int Transaction Organization Unit    
    tran_type sql_variant Transaction Type    
    tran_no   Transaction Number    
    tran_date datetime Transaction Date    
    component_id sql_variant Component Id    
    lo_id   Logistics Organization Id    
    company_code   Company Code    
    bu_id   Business Unit Id    
    fb_id   Financen Book Id    
    supp_ou int Supplier Organization Unit    
    supplier_code sql_variant Supplier Code    
    supp_name   Supplier Name    
    supp_inv_no   Supplier Invoice Number    
    pay_term   Pay Term    
    payterm_version int Pay Term Version    
    doc_status sql_variant Document Status    
    reversed_docno   Reversed Document Number    
    reversal_date datetime Reversal Date    
    bank_code sql_variant Bank Code    
    checkseries_no   Check Series Number    
    check_no   Check Number    
    paid_status   Paid Status    
    vat_applicable   Value Added Tax Applicable    
    discount_proportional   Discount Proportional    
    discount_amount bigint Discount Amount    
    discount_availed   Discount Availed    
    penalty_amount   Penalty Amount    
    reversed_docou int Reversed Document Organization Unit    
    bankcashcode sql_variant Bank Cash Code    
    line_no int Line Number    
    account_code sql_variant Account Code    
    account_desc   Account Description    
    drcr_flag   Debit Credit Flag    
    ctrl_acct_type   Control Account Type    
    auto_post_acct_type   Auto Posted Account Type    
    tran_currency   Transaction Currency    
    acct_currency   Account Currency    
    tran_amount_acc_cur bigint Transaction Amount Account Currency    
    exchange_rate   Exchange Rate    
    base_amount   Base Amount    
    par_exchange_rate   Parallel Exchange Rate    
    par_base_amount   Parallel Base Amount    
    narration sql_variant Narration    
    ref_doc_ou int Reference Document Organization Unit    
    ref_doc_fb_id sql_variant Reference Document Finance Book Id    
    ref_doc_type   Reference Document Type    
    ref_doc_no   Reference Document Number    
    auth_date datetime Authorized Date    
    posting_date   Posting Date    
    posting_status sql_variant Posting Status    
    analysis_code   Analysis Code    
    subanalysis_code   Subanalysis Code    
    cost_center   Cost Center    
    supp_control_acct_type   Supplier Control Account Type    
    supplier_type   Supplier Type    
    flag_op      
    sequence_no int Sequence Number    
    flag_adj sql_variant Flag Adjustment    
    document_grp_ou int Document Group Organization Unit    
    document_grp_no sql_variant Document Group Number    
    document_grp_type   Document Group Type    
    doc_balance bigint Document Balance    
    debit_accnt_code sql_variant Debit Account Code    
    debit_accnt_desc   Debit Account Description    
    cur_option_dr_amt bigint Currency Option Debit Amount    
    cur_option_cr_amt   Currency Option Credit Amount    
    company_name sql_variant Company Name    
    short_desc   Short Description    
    doc_due_date datetime Document Due Date    
    doc_term_no sql_variant Document Term Number    
    doc_due_amount bigint Document Due Amount    
    contact_person sql_variant Contact Person    
    Address1   Address 1    
    address2   Address 2    
    address3   Address 3    
    city   City    
    state   State    
    country   Country    
    zip   Zip    
  repspm_sup_age_tmp ageinganalysis   Ageing Analysis    
    amount bigint Amount    
    amount1   Amount 1    
    amountconsidered   Amount Considered    
    amountdue   Amount Due    
    amountfrom   Amount From    
    amountin   Amount Information    
    amountml   Amount Multiple Line    
    amountto   Amount To    
    amountto1   Amount To 1    
    asondate datetime As On Date    
    bu sql_variant Business Unit    
    cm_docid   Document Id    
    companycode   Company Code    
    companyname   Company Name    
    crtdatmlt   Credit Amount    
    currencycodeml   Currency Code Multiple Line    
    currencyoption   Currency Option    
    desc4   Description 4    
    desc1   Description 1    
    desc2   Description 2    
    desc255   Description 255    
    desc3   Description 3    
    description2   Description 2    
    description3   Description 3    
    descriptionfrom   Description From    
    descriptionhdr   Description Header    
    descriptionto   Description To    
    fb   Finance Book    
    includeprepayments   Include Prepayment    
    language   Language    
    suppliercodeto   Supplier Code To    
    supplierfrom   Supplier From    
    suppliergroup   Supplier Group    
    suppliername   Supplier Name    
    totalpayamount bigint Total Pay Amount    
    guid sql_variant Guid    
    supplier_code   Supplier Code    
    tran_date datetime Transaction Date    
    tran_amount bigint Transaction Amount    
  repspm_supp_details To store information about Supplier details  for reporting purposes guid sql_variant Guid    
      suppcode   Supplier Code    
      suppname   Supplier Name    
      suppgroupcode   Supplier Group Code    
      purpose   Purpose    
      status   Status    
  repspm_supp_recipt_rpt To store information about Supplier Receipts for reporting purposes receipt_no   Receipt Number    
      receipt_date datetime Receipt Date    
      Status sql_variant Status    
      fb   Finance Book    
      supplier_code   Supplier Code    
      supplier_name   Supplier Name    
      amount bigint Amount    
      currency sql_variant Currency    
      receipt_mode   Receipt Mode    
      inst_no   Instrument Number    
      inst_date datetime Instrument Date    
      inst_amt bigint Instrument Amount    
      bank_code sql_variant Bank Code    
      micr_no   MICR number    
      cost_center   Cost Center    
      analysis_code   Analysis Code    
      sub_analysis_code   Subanalysis Code    
      receipt_type   Receipt Type    
      exch_rate bigint Exchange Rate    
      guid sql_variant Guid    
  si_cursor_tmp          
    ou_id int Organization Unit Id    
    company_code sql_variant Company Code    
    bu_id   Business Unit Id    
    fb_id   Finance Book Id    
    supplier_code   Supplier Code    
    account_code   Account Code    
    currency_code   Currency Code    
    account_type   Account Type    
    tran_drcr_flag   Transaction Debit Credit Flag    
    base_drcr_flag   Base Debit Credit Flag    
    pab_drcr_flag   Parallel base amount Debit/Credit Flag    
    tran_balance bigint Transaction Balance    
    base_balance   Base Balance    
    pab_balance   Parallel base Balance amount    
    cb_credit   Closing Balance Credit    
    cb_debit   Closing Balance Debit    
    balance_type sql_variant Balance Type    
    srno int Serial Number    
  si_doc_acct_info_tmp guid sql_variant Guid    
    tran_ou int Transaction Organization Unit    
    tran_type sql_variant Transaction Type    
    tran_no   Transaction Number    
    tran_date datetime Transaction Date    
    component_id sql_variant Component Id    
    lo_id   Logistics Organization Id    
    company_code   Company Code    
    bu_id   Business Unit Id    
    fb_id   Finance Book Id    
    supp_ou int Supplier Organization Unit    
    supplier_code sql_variant Supplier Code    
    supp_name   Supplier Name    
    supp_inv_no   Supplier Invoice Number    
    pay_term   Pay Term    
    payterm_version int Pay Term Version    
    doc_status sql_variant Document Status    
    reversed_docno   Reversed Document Number    
    reversal_date datetime Reversal Date    
    bank_code sql_variant Bank Code    
    checkseries_no   Check Series Number    
    check_no   Check Number    
    paid_status   Paid Status    
    vat_applicable   Value Added Tax Applicable    
    discount_proportional   Discount Proportional    
    discount_amount bigint Discount Amount    
    discount_availed   Discount Availed    
    penalty_amount   Penalty Amount    
    reversed_docou int Reversed Document Organization Unit    
    bankcashcode sql_variant Bank Cash Code    
    line_no int Line Number    
    account_code sql_variant Account Code    
    drcr_flag   Debit Credit Flag    
    ctrl_acct_type   Control Account Type    
    auto_post_acct_type   Auto Posted Account Type    
    tran_currency   Transaction Currency    
    acct_currency   Account Currency    
    tran_amount_acc_cur bigint Transaction Amount Account Currency    
    exchange_rate   Exchange Rate    
    base_amount   Base Amount    
    par_exchange_rate   Parallel Exchange Rate    
    par_base_amount   Parallel Base Amount    
    narration sql_variant Narration    
    ref_doc_ou int Reference Document Organization Unit    
    ref_doc_fb_id sql_variant Reference Document Finance Book Id    
    ref_doc_type   Reference Document Type    
    ref_doc_no   Reference Document Number    
    auth_date datetime Authorized Date    
    posting_date   Posting Date    
    posting_status sql_variant Posting Status    
    txnou_id int Transaction Organization Unit Id    
    tran_qty bigint Transaction Quantity    
    analysis_code sql_variant Analysis Code    
    subanalysis_code   Subanalysis Code    
    cost_center   Cost Center    
  si_supp_bal_rpt_summ_tmp guid   Guid    
    start_date datetime Start Date    
    end_date   End Date    
    company_code sql_variant Company Code    
    bu_id   Business Unit Id    
    ou_id int Organization Unit Id    
    fb_id sql_variant Finance Book Id    
    supplier_code   Supplier Code    
    supp_name   Supplier Name    
    account_code   Account Code    
    account_type   Account Type    
    acct_currency   Account Currency    
    pr_cr_tran_amount bigint Period Credit Transaction Amount    
    pr_dr_tran_amount   Period Debit Transaction Amount    
    pr_cr_base_amount   Period Credit Base Amount    
    pr_dr_base_amount   Period Debit Base Amount    
    pr_cr_pab_amount   Period Credit Parallel Base Amount    
    pr_dr_pab_amount   Period Debit Parallel Base Amount    
    op_balance_tran   Opening Balance Transaction Amount    
    op_balance_base   Opening Balance Base Amount    
    op_balance_pab      
    tran_drcr_flag sql_variant Transaction Debit Credit Flag    
    base_drcr_flag   Base Debit Credit Flag    
    pab_drcr_flag   Parallel Base Credit /    
    company_name   Company Name    
    account_desc   Account Description    
    op_balance bigint Opening Balance    
    pr_cr_balance      
    pr_dr_balance      
    tran_type sql_variant Transaction Type    
    contact_person   Contact Person    
    address1   Address 1    
    address2   Address 2    
    address3   Address 3    
    city   City    
    state   State    
    country   Country    
    zip   Zip    
  si_supplier_balance_rpt_tmp guid   Guid    
    ou_id int Organization Unit Id    
    company_code sql_variant Company Code    
    bu_id   Business Unit Id    
    fb_id   Finance Book Id    
    as_on_date datetime As On Date    
    supplier_code sql_variant Supplier Code    
    account_code   Account Code    
    currency_code   Currency Code    
    account_type   Account Flag    
    tran_drcr_flag   Transaction Debit Credit Flag    
    base_drcr_flag   Base Debit Credit Flag    
    pab_drcr_flag   Parallel Base Credit / Debit Flag    
    tran_balance bigint Transaction Balance    
    base_balance   Base Balance    
    pab_balance   Parallel Base Balance Amount