Table Owner | Table Name | Table Comment | Table Column Name | Table Column Datatype | Table Column Comment | Table Column Is PK | Table Column Is FK |
---|---|---|---|---|---|---|---|
dbo | spo_inv_pay_tmp | guid | sql_variant | Guid | No | No | |
  |   | doc_no |   | Document Number |   |   | |
  |   | doc_amt | bigint | Document Amount |   |   | |
  |   | doc_date | datetime | Document Date |   |   | |
  |   | doc_type | sql_variant | Document Type |   |   | |
  |   | currency |   | Currency |   |   | |
  |   | supp_inv_no |   | Supplier Invoice Number |   |   | |
  |   | inst_no |   | Instrument Number |   |   | |
  |   | inst_date | datetime | Instrument Date |   |   | |
  |   | inst_amt | bigint | Instrument Amount |   |   | |
  |   | inst_type | sql_variant | Instrument Type |   |   | |
  |   | bank |   | Bank |   |   | |
  |   | due_date | datetime | Due Date |   |   | |
  |   | due_amt | bigint | Due Amount |   |   | |
  |   | createdby | sql_variant | Created By |   |   | |
  |   | createddate | datetime | Created Date |   |   | |
  |   | modifiedby | sql_variant | Modified By |   |   | |
  |   | modifieddate | datetime | Modified Date |   |   | |
  | spo_pay_tmp | guid | sql_variant | Guid |   |   | |
  |   | instr_type |   | Instrument Type |   |   | |
  |   | instr_no |   | Instrument Number |   |   | |
  |   | currency |   | Currency |   |   | |
  |   | instr_amount | bigint | Instrument Amount |   |   | |
  |   | instr_date | datetime | Instrument Date |   |   | |
  |   | bank_name | sql_variant | Bank Name |   |   | |
  |   | voucher_no |   | Voucher Number |   |   | |
  |   | voucher_date | datetime | Voucher Date |   |   | |
  |   | payment_type | sql_variant | Payment Type |   |   | |
  |   | supp_inv_no |   | Supplier Invoice Number |   |   | |
  | spo_supplier_mst | supplier_code |   | Supplier Code |   |   | |
  |   | supplier_name |   | Supplier Name |   |   | |
  |   | lo_id |   | Logistics Organization Id |   |   | |
  |   | bu_id |   | Business Unit Id |   |   | |
  |   | ou_id | int | Organization Unit Id |   |   | |
  |   | login_user | sql_variant | Login User |   |   | |
  |   | login_ou | int | Login Organization Unit |   |   |