| id |
integer |
Yes |
Yes |
nextval('purchase_orders_id_seq'::regclass) |
|
| po_number |
character varying(10) |
No |
No |
|
Purchase Order number |
| vendor_no |
character varying(20) |
No |
No |
|
Vendor code - links to vendors.vendor_no |
| vendor_name |
character varying(60) |
No |
No |
|
Vendor name |
| vendor_po |
character varying(20) |
No |
No |
|
Vendor Order number |
| date |
date |
No |
No |
|
Purchase Order date |
| status |
character varying(1) |
No |
No |
|
Purchase Order status; C= Closed (only exists if Purchase Order failed move to history) I = Issued H = Hold O = Open R = Received S = Standing |
| required_date |
date |
No |
No |
|
Required date on Purchase Order |
| received_date |
date |
No |
No |
|
Last received date on Purchase Order |
| buyer_name |
character varying(60) |
No |
No |
|
Buyer name on Purchase Order |
| discount |
numeric(5,2) |
No |
No |
|
Doscount % on the Purchase Order |
| terms_code |
character varying(10) |
No |
No |
|
Terms code for Purchase Order, will be used to populate the Vendor Invoice - Links to payment_terms.terms_code |
| terms_description |
character varying(60) |
No |
No |
|
Payment Terms description, will be used to populate the Vendor Invoice |
| terms_days_before_due |
smallint |
No |
No |
|
Number of days before the payment is due calculated from transaction date, will be used to populate the Vendor Invoice |
| terms_days_allowed |
smallint |
No |
No |
|
Number of days allowed for discount, will be used to populate the Vendor Invoice |
| terms_discount_rate |
numeric(5,2) |
No |
No |
|
Early payment discount percentage rate, will be used to populate the Vendor Invoice |
| ship_id |
character varying(20) |
Yes |
No |
|
Not used |
| currency |
character varying(3) |
No |
No |
|
Vendor currency; blank = base currency - links to currencies.code |
| currency_rate_method |
character varying(1) |
No |
No |
|
Currency rate conversion method used; / = direct * = indirect |
| currency_rate |
numeric(13,7) |
No |
No |
|
Currency rate used |
| fob |
character varying(20) |
No |
No |
|
Free on board location |
| freight_balance |
numeric(15,2) |
No |
No |
|
Freight balance accrued, not invoiced |
| ship_via_code |
character varying(10) |
No |
No |
|
Ship Via code - links to shipping_methods.code |
| ref_no |
character varying(20) |
No |
No |
|
Reference number as set by user |
| serialized_items |
boolean |
No |
No |
|
Purchase Order has serialized items |
| subtotal |
numeric(15,2) |
No |
No |
|
Subtotal before taxes, freight and discount |
| total_discount |
numeric(15,2) |
No |
No |
|
Total discount amount |
| freight |
numeric(15,2) |
No |
No |
|
Vendor Freight on entire Purchase Order |
| sales_tax |
numeric(15,2) |
No |
No |
|
Total sales tax for Purchase Order on received items |
| gross_profit |
numeric(15,2) |
No |
No |
|
Gross Profit for Purchase Order if Status = Issued, Gross Profit on received items if Status = Received |
| total_current_cost |
numeric(15,2) |
No |
No |
|
Not used |
| total_average_cost |
numeric(15,2) |
No |
No |
|
Not used |
| total |
numeric(15,2) |
No |
No |
|
Total for Purchase Order if Status = Issued, total on received items if Status = Received |
| po_amount |
numeric(15,2) |
No |
No |
|
Total value of products ordered |
| amount_received |
numeric(15,2) |
No |
No |
|
Total Amount received to date |
| landed_freight |
numeric(15,5) |
No |
No |
|
Landed freight to date |
| landed_duty |
numeric(15,5) |
No |
No |
|
Landed duty to date |
| issued_amt |
numeric(15,5) |
No |
No |
|
Issued amount |
| accrued_to_date |
numeric(15,5) |
No |
No |
|
Accrued receipts to date |
| invoiced_bal |
numeric(15,2) |
No |
No |
|
Amount to send to Accounts payable |
| invoiced_net |
numeric(15,2) |
No |
No |
|
Net amount for account payable |
| print_date |
date |
No |
No |
|
Date Purchase Order was Issued and Print dialog presented |
| print_init |
character varying(3) |
No |
No |
|
User initials that Issued the Purchase Order and had the oppurtunity to Print |
| subtotal_issued |
numeric(15,2) |
No |
No |
|
Subtotal of product on Purchase Order when Issued |
| total_discount_issued |
numeric(15,2) |
No |
No |
|
Total discount on Purchase Order when Issued |
| freight_issued |
numeric(15,2) |
No |
No |
|
Freight on Purchase Order when Issued |
| sales_tax_issued |
numeric(15,2) |
No |
No |
|
Total sales tax on Purchase Order when Issued |
| gross_profit_issued |
numeric(15,2) |
No |
No |
|
Gross profit on Purchase Order when Issued |
| current_cost_issued |
numeric(15,2) |
No |
No |
|
Not used |
| average_cost_issued |
numeric(15,2) |
No |
No |
|
Not used |
| total_issued |
numeric(15,2) |
No |
No |
|
Purchase Order total when Issued |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| whse |
character varying(6) |
No |
No |
|
Purcahse Order warehouse, used as default for items to order - links to inventory_warehouses.whse |
| ship_customer |
character varying(20) |
No |
No |
|
Customer selected for drop ship - links to customers.cust_no |
| customer_ship_type |
character varying(1) |
No |
No |
|
Not used |
| customer_ship_id |
character varying(20) |
No |
No |
|
Customer ShipToID selected for drop ship - links to addresses.ship_id with cust_no |
| location |
character varying(24) |
No |
No |
|
General Ledger Location segment of the warehouse for companies using Location accounting |
| division |
character varying(3) |
No |
No |
|
Division code for Purchase Order as per divisions in the company; 000 = non divisionalized company - links to gl_divisions.code |
| phase_id |
character varying(20) |
No |
No |
|
Current phase ID of the Purchase Order - links to phases.phase_id |
| user_type |
character varying(40) |
No |
No |
|
Not used |
| job_no |
character varying(10) |
No |
No |
|
Job cost number - links to jobs.job_no |
| job_acct_no |
character varying(10) |
No |
No |
|
Job cost account number - links to jobs.account |
| weight |
numeric(15,2) |
No |
No |
0 |
Total weight on Purchase Order |
| sales_tax_rate |
numeric(7,4)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Sales tax rates 1 - 4 used on Purchase Order |
| sales_tax_applicable |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Sales tax applicable flags 1 - 4 used on Purchase Order |
| sales_tax_total |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Sales tax totals 1 - 4 on Purchase Order |
| sales_tax_applicable_issued |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Sales tax applicable flags 1 - 4 used on Purchase Order when Issued |
| sales_tax_total_issued |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Sales tax totals 1 - 4 on Purchase Order when Issued |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |