Supplier Balance Information

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