Invc Head

Unique invoice number, generated from a sequence.

Type of the invoice. Valid values are: I for Merchandise Invoice, N for Non-Merchandise Invoice, O for Consignment Customer Sales Invoice, C for Credit Note, D for Debit Memo, M for Credit Memo, R for Credit Note Request, P for Consignment Customer Return Debit Memo, T for Consignment Transfer Invoice, V for Consignment Transfer Debit Memo, S for Consignment Ownership Change Invoice, W for Consignment Ownership Change Debit Memo, E for Consignment External Return Debit Memo, G for Consignment External Credit Note Request. Invoice types will be held on the codes table under a code type of IMIT.

Invoice suppliers number. Oracle Retail target column SUPPLIER on INVC_HEAD.

Any given supplier-generated invoice number.

Code for the status of the invoice. Valid values are U for unmatched, R for partially matched, M for matched, A for approved and P for posted.

Indicates whether or not an invoice was uploaded via EDI. Valid values are Y or N.

Shows if this invoice has been dowloaded via EDI yet or not.

Indicates whether or not an invoice has failed a match attempt. Valid values are Y or N.

For invoice types C, D or R, the invoice that the credit note, debit memo or credit note request was raised against.

For invoice types C, D or R, the RTV that the credit note, debit memo or credit note request was raised against.

The number that uniquely identifies a price change associated with this invoice. This is the number of the price change that is vendor funded and when the price change is extracted generates a credit memo invoice.

For invoice types C, D or R, the reason that the credit note, debit memo or credit note request was Other values may be added by the client as desired, raised. Valid values include Q for quantity discrepancy, C for cost discrepancy, D for discount discrepancy, V for VAT discrepancy or R for RTV. Other values may be added by the client as desired.

Indicator identifying the payment terms for the invoice. These terms specify when payment is due and if discounts exist for payment by the due date.

Date the invoice is due to be paid, defaulted according to the payment terms negotiated with the supplier.

Code identifying the payment method for the invoice, indicating how the invoice will be paid. Valid values include LC for letter of credit, WT for wire transfer, and OA for open account. Other values maybe added by the client as desired. Payment methods will be held on the codes table under a code type of PAYM.

Discount that will be applied to the invoice if the invoice is paid by the due date.

Indicates whether or not the terms discount has been applied to the total cost of the invoice or not. Valid values are Y or N.

This field will indicate if the specified terms discount should be applied to non-merchandise costs.

Indicator that references the freight terms associated with the invoice.

Oracle user ID of the user that entered the invoice into the system. If the invoice was entered via EDI, this field will be populated with EDI.

Date the invoice was entered into the system, either manually or via EDI.

Date the invoice was issued by the supplier.

Oracle user ID of the user that matched the invoice.

Date the invoice was matched. Oracle Retail target column MATCH_DATE on INVC_HEAD.

Oracle user ID of the user that approved the invoice match.

Date the invoice match was approved.

Indicates whether or not the invoice is to be force paid (paid before being matched to receipts). Valid values are Y or N.

Oracle ID of the user that marked the invoice for force payment. This field will only have a value if the force_pay_ind = Y.

Date the invoice was posted to the AP staging tables.

Code identifying the currency in which the invoice is held.

Exchange rate at which the invoice is held.

Total merchandise cost for the invoice. This field will be held in the invoice currency.

Total quantity of items on the invoice. This field is optional, and only needs to be entered if total quantity matching will be performed on the invoice.

Indicates whether the invoice was created for a direct store delivery order via the Quick Order Entry form in which the invoice was already paid. Valid values are Y -Yes and N -No.

Type of partner assigned to the invoice. Valid values include Bank BK, Agent AG, Freight Forwarder FF, Importer IM, Broker BR, Factory FA, Applicant AP, Consolidator CO, Consignee CN, Supplier Hierarchy Level 1 S1, Supplier Hierarchy Level 2 S2, and Supplier Hierarchy Level 3 S3. These partner types will be held on the codes table under the code_type PTAL.

Partner assigned to the invoice. Partners can be assigned to any invoice type except merchandise invoices.

Indicates which vendor invoice address should be associated with the invoice.

Indicates if the invoice has already been paid. Valid values are Y (invoice has already been paid) or N (invoice should be paid in AP system).

Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA

Date that the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA.

Proof of delivery or service number, given at the time of receipt at the store. This field will be populated when the invoice is interfaced through ReSA.

Customs entry ID of the custom entry from which the invoice was created. This field will only be populated for invoices created from customs entry.

Obligation key of the obligation from which the invoice was created. This field will only be populated for invoices created from obligations.

Free-form comments entered with the invoice.