new_POBase

6171 rows


Description

Purchase Orders

Columns

Column Type Size Nulls Auto Default Children Parents Comments
new_POId uuid 2147483647 √ null
CreatedOn timestamp 26,3 √ null
CreatedBy uuid 2147483647 √ null
OwnerId uuid 2147483647 √ null
statecode int4 10 0
statuscode int4 10 null
PurchaseOrderStatus.id new_POBase_statuscode_fkeyR
TransactionCurrencyId uuid 2147483647 √ null
ExchangeRate numeric 25,10 √ null
new_Company uuid 2147483647 √ null
new_RelatedOrder uuid 2147483647 √ null
new_paymentmethoddm uuid 2147483647 √ null
new_RecurringPayment uuid 2147483647 √ null
new_PaidBy uuid 2147483647 √ null
new_DueDate timestamp 26,3 √ null
new_TotalContentCost numeric 19,4 √ null
new_BonusIfany numeric 19,4 √ null
new_name varchar 100 √ null
new_PaymentType int4 10 √ null
new_Sum numeric 19,4 √ null
new_PaymentMethod int4 10 √ null
new_Description text 2147483647 √ null
new_PostStartDate timestamp 26,3 √ null
new_PostEndDate timestamp 26,3 √ null
new_ApprovedOn timestamp 26,3 √ null
new_PaidOn date 13 √ null
new_PaymentAddress varchar 150 √ null
new_paymentmethodnew uuid 2147483647 √ null
new_customertype bool 1 √ null
new_ponumber varchar 30 √ null
new_FromCompanyPayment int4 10 √ null
new_servedon timestamp 26,3 √ null
new_checknumber varchar 100 √ null
new_purchaseordermarkedpaidon timestamp 26,3 √ null
new_ProviderInvoiceid varchar 100 √ null
new_total numeric 19,4 √ null
new_total_Base numeric 19,4 √ null
id serial 10 √ nextval('v1."new_POBase_id_seq"'::regclass)
Posts.po_id Posts_po_id_fkeyR
PoToPosts.po_id PoToPosts_po_id_fkeyR
owner_id int4 10 √ null
SystemUserBase.id new_POBase_owner_id_fkeyR
createdby_id int4 10 √ null
SystemUserBase.id new_POBase_createdby_id_fkeyR
approvedby_id int4 10 √ null
SystemUserBase.id new_POBase_approvedby_id_fkeyR
supplier_id int4 10 √ null
ContactBase.id new_POBase_supplier_id_fkeyR
paymentmethod_id int4 10 √ null
new_paymentmethodBase.id new_POBase_paymentmethod_id_fkeyR
currency_id int4 10 √ null
TransactionCurrencyBase.id new_POBase_currency_id_fkeyR
paidby_id int4 10 √ null
SystemUserBase.id new_POBase_paidby_id_fkeyR
company_id int4 10 √ null
AccountBase.id new_POBase_company_id_fkeyR
status_change_reason text 2147483647 √ null
po_id int4 10 √ null
euro_equivalent numeric 0 √ null
CancelledBy int4 10 √ null
SystemUserBase.id new_POBase_CancelledBy_fkeyR
CancelledOn timestamptz 35,6 √ null
writer_id int4 10 √ null
ContactBase.id new_POBase_writer_id_fkeyR
transactionId varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
new_POBase_pkey Primary key Asc id
new_POBase_id_key Must be unique Asc id
po_name_index Performance Asc new_name
po_statecode_index Performance Asc statecode

Relationships

Close relationships within degrees of separation