| id |
integer |
Yes |
Yes |
nextval('purchase_history_id_seq'::regclass) |
|
| po_number |
character varying(10) |
No |
No |
|
Purchase order number |
| vendor_no |
character varying(20) |
No |
No |
|
Vendor code |
| 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 - Always 'C' - Closed |
| required_date |
date |
No |
No |
|
Required date |
| received_date |
date |
No |
No |
|
Last received date |
| buyer_name |
character varying(60) |
No |
No |
|
Buyer name |
| discount |
numeric(5,2) |
No |
No |
0 |
Footer discount |
| terms_code |
character varying(10) |
No |
No |
|
Payment terms code |
| terms_description |
character varying(60) |
No |
No |
|
Payment terms description |
| terms_days_before_due |
smallint |
No |
No |
|
Terms days before due |
| terms_days_allowed |
smallint |
No |
No |
|
Terms days allowed for discount |
| terms_discount_rate |
numeric(5,2) |
No |
No |
0 |
Terms discount percentage rate |
| ship_id |
character varying(20) |
No |
No |
|
Customer Ship ID |
| currency |
character varying(3) |
No |
No |
|
Currency |
| currency_rate_method |
character varying(1) |
No |
No |
|
|
| currency_rate |
numeric(13,7) |
No |
No |
0 |
Currency rate |
| fob |
character varying(20) |
No |
No |
|
FOB - Free on board |
| freight_balance |
numeric(15,2) |
No |
No |
0 |
Freight balance |
| ship_via_code |
character varying(10) |
No |
No |
|
Ship via code |
| ref_no |
character varying(20) |
No |
No |
|
Reference number |
| serialized_items |
boolean |
No |
No |
|
Has serialized items on PO |
| subtotal |
numeric(15,2) |
No |
No |
0 |
Sub total before discount, taxes and freight |
| total_discount |
numeric(15,2) |
No |
No |
0 |
Total discount amount |
| freight |
numeric(15,2) |
No |
No |
0 |
Freight amount |
| sales_tax |
numeric(15,2) |
No |
No |
0 |
Total sales tax amount |
| gross_profit |
numeric(15,2) |
No |
No |
0 |
|
| total_current_cost |
numeric(15,2) |
No |
No |
0 |
|
| total_average_cost |
numeric(15,2) |
No |
No |
0 |
|
| total |
numeric(15,2) |
No |
No |
0 |
PO total |
| ex_date |
date |
No |
No |
|
Expected date |
| invoice |
character varying(10) |
No |
No |
|
|
| print_date |
date |
No |
No |
|
Print date |
| print_init |
character varying(3) |
No |
No |
|
User initials that printed PO |
| _dbversion |
integer |
No |
No |
|
|
| _created |
timestamp without time zone |
No |
No |
|
|
| _created_by |
character varying(3) |
No |
No |
|
|
| _modified |
timestamp without time zone |
No |
No |
|
|
| _modified_by |
character varying(3) |
No |
No |
|
|
| whse |
character varying(6) |
No |
No |
|
Order warehouse |
| ship_customer |
character varying(20) |
No |
No |
|
Ship to customer |
| customer_ship_type |
character varying(1) |
No |
No |
|
|
| customer_ship_id |
character varying(20) |
No |
No |
|
Customer shipto ID |
| location |
character varying(24) |
No |
No |
|
Location |
| division |
character varying(3) |
No |
No |
|
Division |
| phase_id |
character varying(20) |
No |
No |
|
Phase ID PO was in when closed |
| user_type |
character varying(40) |
No |
No |
|
|
| job_no |
character varying(10) |
No |
No |
|
Job code |
| job_acct_no |
character varying(10) |
No |
No |
|
Job account |
| weight |
numeric(15,2) |
No |
No |
0 |
Total PO weight |
| sales_tax_rate |
numeric(7,4)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Array field containing tax rates |
| sales_tax_applicable |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
|
| sales_tax_total |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
|
| udf_data |
hstore |
No |
No |
''::hstore |
hstore field containing user defined data |