Contract Header

This field contains the number that uniquely identifies a contract within the system.

This field indicates the type of contract. Valid values are: A - contracts with a production plan and declared supplier availability, B - contracts with a production plan and no declared supplier availability, C - contracts with no production plan and no supplier availability, D - contracts with no production plan and declared supplier availability

This field contains the department number for the contract. Unlike orders, contracts are always limited to a single department.

This field contains the supplier for the contract. This vendor will provide the merchandise specified in the contract.

This field contains the sales terms for the contract. These terms specify when payment is due and if any discounts exist for early payment.

This field contains the status for the contract. The valid statuses are as follows: W - Worksheet, S - Submitted, A - Approved, R - Reviewed, C - Complete, X - Cancelled

This field contains the date the status was last updated within the system.

This field contains the date the contract was created within the system.

This field contains the Oracle user ID of the person creating the contract.

This field contains the date the contract status is set to submitted.

This field contains the Oracle user ID of the person submitting the contract.

This field contains the date the contract status is set to approved.

This field contains the Oracle user ID of the user approving the contract.

This field contains the date the contract status is set to Review.

This field contains the Oracle user ID of the user reviewing the contract.

This field contains the date the status is set to cancelled.

This field contains the Oracle user ID of the person cancelling the contract.

This field contains the date the contract was completed and closed.

This field contains the contract start date.

This field contains the contract end date.

This field contains the last date an order was created within the system.

This field contains the distributor name who will collect the merchandise from the supplier and deliver to the retailer.

This field contains the abbreviation for the country where the contract originated.

This field contains the currency code for the currency associated with this contract.

This field contains a code representing the method of shipment associated with the contract. Valid values are: AR - Air, RD - Road, SA - Sea, RL - Rail

This field contains the total value of the contract. This amount is the commitment recorded in the Open to Buy module for the contract. This field is only populated for contract types C and D.

This field contains the total cost of items that have not been ordered from the contract. This field is only populated for contract types C and D.

This field contains the estimated duty for the contract. This field can be entered on the contract header form for estimation purposes.

This field contains the estimated expenses for the contract. This field can be entered on the contract header form for estimation purposes.

This field indicates whether or not the contract will be transmitted to the supplier via an EDI transaction. The valid values for this field are: Y - Yes, N - No, S - Sent

This column will indicate whether or not the contract has been sent. Valid values are Yes or No.

This field indicates whether orders attached to the contract require manual approval. Valid values are: Y, N.

This column will determine whether the contract can be ordered against. Valid values are Yes or No.

This field contains the cost that has been raised against the contract by the temporary orders (ORD_TEMP records) during the contract replenishment run. It is used to track cost to ensure that the total cost will not be overrun by the current or concurrent batch processes. The value will be updated in the batch cycle when temporary order records are called against the contract, an will be updated to NULL upon completion.

This field contains any miscellaneous comments attached to the contract.

This column holds Import Country Id.