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 |
|
|