doc_type |
n/a |
n/a |
Yes |
Indicates the
type of document this message is for. Valid value is 'P' for purchase
order. |
order_no |
ordhead |
order_no |
Yes |
Contains the
number that uniquely identifies an order within the system. |
order_type |
ordhead |
order_type |
Yes |
Indicates the
type of order and which Open To Buy bucket will be updated. Valid values
include: 'N/B' - Non Basic 'ARB' - Automatic Reorder of Basic 'BRB' -
Buyer Reorder of Basic. |
order_type_desc |
order_types |
order_types_desc |
Yes |
The description
for the given order type. |
dept |
ordhead |
dept |
No |
Contains the
department number for orders limited to a single department and will be
Null for orders involving items in more than one department. |
dept_name |
deps |
dept_name |
No |
Contains the
name of the department. |
buyer |
ordhead |
buyer |
No |
Contains the
number associated with the buyer for the order. |
buyer_name |
buyer |
buyer_name |
No |
Contains the
name of the authorized buyer. |
supplier |
ordhead |
supplier |
Yes |
Contains the
vendor number who will provide the merchandise specified in the
order. |
promotion |
ordhead |
promotion |
No |
Contains the ad
number associated with the order to provide a link between the order
dialog and the promotions dialog. |
prom_desc |
rpm_promo |
description |
Yes |
Contains a
description of the promotion. This value comes from RPM. |
qc_ind |
ordhead |
qc_ind |
Yes |
Determines
whether or not quality control will be required when items for this order
are received. Valid values are 'Y' and 'N'. |
not_before_date |
ordhead |
not_before_date |
No |
Contains the
first date that delivery of the order will be accepted. |
not_after_date |
ordhead |
not_after_date |
No |
Contains the
last date that delivery of the order will be accepted. |
otb_eow_date |
ordhead |
otb_eow_date |
No |
This field
contains the OTB budget bucket the order amount should be placed
into. |
earliest_ship_date |
ordhead |
earliest_ship_date |
No |
The date before
which the items on the purchase order can not be shipped by the supplier.
Represents the earliest earliest ship date of all the items on the
order. |
latest_ship_date |
ordhead |
latest_ship_date |
No |
The date after
which the items on the purchase order can not be shipped by the supplier.
Represents the greatest latest ship date of all the items on the
order. |
close_date |
ordhead |
close_date |
No |
Contains the
date when the order is closed. |
terms |
ordhead |
terms |
Yes |
Indicator
identifying the sales terms for the order. These terms specify when
payment is due and if any discounts exist for early payment. |
terms_code |
terms |
terms_code |
Yes |
Indicates the
Alphanumeric representation of Term Name which acts as the Term code in
Oracle Financials. |
freight_terms |
ordhead |
freight_terms |
No |
Indicator that
references what freight terms are related to the order. |
cust_order |
ordhead |
cust_order |
Yes |
This field
indicates whether or not the order is generated for a
customer. |
payment_method |
ordhead |
payment_method |
No |
Indicates how
the purchase order will be paid. Valid options are LC (Letter of Credit),
WT (Wire Transfer), OA (Open Account). |
payment_method_desc |
ordhead |
payment_method_desc |
No |
Indicates how
the purchase order will be paid. Valid options are 'LC' - Letter of
Credit, 'WT' - Wire Transfer, 'OA' - Open Account. |
backhaul_type |
ordhead |
backhaul_type |
No |
This field
contains the type of backhaul allowance that will be applied to the order.
Some examples are 'C'alculated or 'F'lat rate |
backhaul_type_desc |
code_detail |
code_desc |
No |
The description
for the given backhaul type. |
backhaul_allowance |
ordhead |
backhaul_allowance |
No |
This field will
contain the backhaul allowance value. |
ship_method |
ordhead |
ship_method |
No |
The method used
to ship the items on the purchase order from the country of origin to the
country of import. |
ship_method_desc |
code_detail |
code_desc |
No |
Contains the
description of the given shipping method. |
purchase_type |
ordhead |
purchase_type |
No |
Indicates what's
included in the supplier's cost of the item. Valid values include C
(Cost), CI (Cost and Insurance), CIF (Cost, Insurance and Freight), FOB
(Free on Board). |
purchase_type_desc |
code_detail |
code_desc |
No |
Contains the
description of the given purchase type. |
status |
ordhead |
status |
Yes |
Indicates the
current status of the order. Valid values include 'W' - Worksheet, 'S' -
Submitted, 'A' - Approved, 'C' - Closed |
ship_pay_method |
ordhead |
ship_pay_method |
No |
Code indicating
the payment terms for freight charges associated with the order. Valid
values inlude: 'CC' - Collect, 'CF' - Collect Freight Credited Back to
Customer, 'DF' - Defined by Buyer and Seller, 'MX' - Mixed, 'PC' - Prepaid
but Charged to Customer, 'PO' - Prepaid Only, 'PP' - Prepaid by
Seller. |
ship_pay_method_desc |
code_detail |
code_desc |
No |
Contains the
description of the given shipment payment method. |
fob_trans_res |
ordhead |
fob_trans_desc |
No |
Contains the
code indicating the type of the location that is responsible for the
transportation of the order. |
fob_trans_res_code_desc |
code_detail |
code_desc |
No |
Contains the
description of the given fob_trans_res_code |
fob_trans_res_desc |
ordhead |
fob_trans_res_desc |
No |
User entered
field describing the code for the location responsible for the
transportation of the order. |
fob_title_pass |
ordhead |
fob_title_pass |
No |
Indicator used
to determine where the title for goods is passed from the vendor to the
purchaser. Examples include city, factory, or origin. |
fob_title_pass_code_desc |
code_detail |
code_desc |
No |
Contains the
description of the given fob_title_pass_code. |
fob_title_pass_desc |
ordhead |
fob_title_pass_desc |
No |
User entered
field describing the code where the title of the merchandise is to be
passed. Could be a city name, factory name, or place of
origin. |
vendor_order_no |
ordhead |
vendor_order_no |
No |
Contains the
vendor's unique identifying number for an order. These orders may have
originated by the vendor through the EDI process or this number can be
associated to a Retek order when the order is created
on-line. |
exchange_rate |
ordhead |
exchange_rate |
No |
The rate of
exchange used for the purchase order between the order and primary
currencies. |
factory |
ordhead |
factory |
No |
The factory at
which the items on the purchase order are made. This field is only
available when the system is running Import functionality. |
factory_desc |
partner |
partner_desc |
No |
Contains the
description of the given factory. |
agent |
ordhead |
agent |
No |
The agent that
is used in the purchase of the items on the purchase order. This field is
only available when the system is running Import
functionality. |
agent_desc |
partner |
partner_desc |
No |
Contains the
description of the given partner |
discharge_port |
ordhead |
discharge_port |
No |
The port at
which the items on the purchase order will enter the country of import.
This field is only available when the system is running Import
functionality. |
discharge_port_desc |
outloc |
outloc_desc |
No |
Contains the
description of the given discharge port. |
lading_port |
ordhead |
lading_port |
No |
The port from
which the items on the purchase order are shipped. This field is only
available when the system is running Import functionality. |
lading_port_desc |
outloc |
outloc_desc |
No |
Contains the
description of the given lading port. |
bill_to_id |
ordhead |
bill_to_id |
No |
Indicates the ID
of the bill-to-address, which will be stored on the OUTLOC table under the
outloc_type 'BT'. |
freight_contract_no |
ordhead |
freight_contract_no |
No |
The number of
the contract with a shipper that will give specific freight rates. This
field is only available when the system is running Import
functionality. |
po_type |
ordhead |
po_type |
No |
Contains the
value associated with the PO_TYPE for the order. |
po_type_desc |
po_type |
po_type_desc |
No |
Contains a
description for the specific PO_TYPE |
pre_mark_ind |
ordhead |
pre_mark_ind |
Yes |
This field
indicated whether or not a supplier has agreed to break an order into
separate boxes so that the boxes can be sent directly to
stores. |
currency_code |
ordhead |
currency_code |
Yes |
Contains the
currency code for the order. When creating an order within Retek, this
field will always default to the currency of the supplier, but it can be
overwritten. |
contract_no |
ordhead |
contract_no |
No |
Contains the
contract number associated with this order. |
pickup_loc |
ordhead |
pickup_loc |
No |
Contains the
location at which the order will be picked up, if the order is a 'Pickup'
order. |
pickup_no |
ordhead |
pickup_no |
No |
Contains the
reference number of the 'Pickup' order. |
pickup_date |
ordhead |
pickup_date |
No |
Contains the
date when the order can be picked up from the Supplier. This field is only
required if the Purchase Type of the order is 'Pickup'. |
app_datetime |
ordhead |
app_datetime |
No |
This column will
hold the date and time of the receiving appointment at the
warehouse. |
comment_desc |
ordhead |
comment_desc |
No |
Any
miscellaneous comments attached to the purchase order. |
PODtl |
* |
* |
* |
* |