IM Invoice Detail

this column holds the document to which this detail record belongs.

this column holds the transaction level item that is on the document. transaction level item means that the item is managed at this level in the merchandising system. for rms 9, this could be either a pack, fashion sku or staple sku, but this could not be a fashion style. for rms 10, this must be a transaction level. this column is mandatory not null.

this column specifies the unit cost of the invoice line.

this column specifies the invoice quantity for the invoice line.

this column specifies the resolution adjusted unit cost. it is defaulted to the unit cost when the invoice line is first created.

this column specifies the resolution adjusted quantity invoiced. it is defaulted to the invoice quantity when the invoice line is first created.

this column holds the status of the document line item. valid values are unmtch - unmatched, pmtch for partially matched and mtch for matched. this column is mandatory not null.

this column indicates if the invoice line is already cost matched.

this column indicates if the invoice line is already quantity matched.

this column will hold the cost variance within tolerance for an invoice line or potentially for a set of invoice lines. the variance will represent any difference within tolerance between invoice unit cost and order unit cost. in the case of an invoice line that has been resolved via a cost discrepancy resolution, the variance will represent any difference unexplained by resolution actions but that is still within tolerance.

this column will hold the quantity variance within tolerance for an invoice line or potentially for a set of invoice lines. the variance will represent any difference within tolerance between invoice quantity and order quantity. in the case of an invoice line that has been resolved via a quantity discrepancy resolution, the variance will represent any difference unexplained by resolution actions but that is still within tolerance.

the column indicates whether there are receiver (cost/unit) adjustments pending. value is default n. value is y when a discrepancy resolution action is a receiver adjustment and the merchandise system has not been adjusted. value is set back to n once invoice match determines that the adjustment has been done in the merchandise system.

The username identifier of the user who last updated a record.

The date a record was last updated.

indicates if the current line items state is tax discrepant. n or null mean the line is not discrepant.

unit freight for an item Oracle Retail target column UNIT_FREIGHT on IM_INVOICE_DETAIL.

maximum retail price for an item

unit retail price for an item Oracle Retail target column UNIT_RETAIL on IM_INVOICE_DETAIL.

The username identifier of the user who created a record.

The date a record was created.

The version identifier for a record. Unique for each state of a single record.