Invc Detail Temp2

Unique invoice number. Oracle Retail target column INVC_ID on INVC_DETAIL_TEMP2.

Unique identifier for the item.

The unique identifier for an item that references the other.

Unit cost that the SKU has been invoiced at, as entered by the user. This value can be edited at any time until the invoice is matched. This field will be held in the invoice currency.

Quantity of the SKU that has been invoiced for, as entered by the user. This value can be edited at any time until the invoice is matched.

This column will be updated by prepost posupld function. The value will be null if the row is a new and will have U if the row is already in invc_detail table.

VAT rate applied to the SKU that has been invoiced for, as entered by the user. This value can be edited at any time until the invoice is matched.

Status of the invoice line item. Valid values are U for unmatched, R for partially matched and M for matched.

Unit cost that the SKU has been invoiced at, captured at the time of invoice entry. This value can be used to revert the invoice back to its original values after it has been edited. This field will be held in the invoice currency.

Quantity of the SKU that has been invoiced for, captured at the time of invoice entry. This value can be used to revert the invoice back to its original values after it has been edited.

VAT rate applied to the SKU that has been invoiced for. This value is captured at the time the invoice is entered and can be used to revert the invoice back to its original values after it has been edited.

Indicates if the invoice unit cost falls outside of tolerance of the receipt unit cost matched to it. Valid values are Y and N.

Indicates if the invoice quantity falls outside of tolerance of the receipt quantity matched to it. Valid values are Y and N.

Indicates if the invoice VAT rate is different than the VAT rate held in the system for the SKU. Valid values are Y and N.

Indicator that can be used by the user to mark lines that have been looked at. Valid values are Y and N.

Comments attached to the line. Use of this field will only be available when the line has a discrepancy.

holds the date the record was added or changed

It contains the VAT Code Oracle Retail target column VAT_CODE on INVC_DETAIL_TEMP2.