CMR_ACCRUAL_ADJ_POS_GT

This table stores purchase orders cleared using adjust accrual process and used in accounting events creation.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
CMR_PO_DISTRIBUTION_ID	NUMBER		18	This column indicates the receipt accounting purchase order distribution identifier.
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Indicates the receipt accounting purchase order schedule identifier.
BUSINESS_UNIT_ID	NUMBER		18	Indicates the profit center business unit on accrual clearing transaction.
BILL_TO_BUSINESS_UNIT_ID	NUMBER		18	Bill to business unit identifier that will create the invoice for the purchase.
INVENTORY_ORG_ID	NUMBER		18	Inventory organization identifier where the material is scheduled to be received.
ACCRUAL_CLEARED_USER	VARCHAR2	64		User performing the accrual clearing transactions. This is to avoid the same user doing accrual clearing at the same time.
ACCRUAL_CLR_REASON_DESC	VARCHAR2	100		User entered accrual clearing reason description while performing clearing transaction.
ACCRUAL_CLR_AMT	NUMBER			Accrual amount cleared by user at the time of transaction creation.
TRANSACTION_DATE	TIMESTAMP			Latest transaction date on purchase order distribution or schedule.
LATEST_ACCOUNTING_EVENT_ID	NUMBER		18	Latest accounting event identifier that references to events in receipt accounting.
ACCRUAL_CLR_ID	NUMBER		18	Stores the accrual clear identifier while performing clearing or reversal.
ACCRUAL_GROUP_ID	NUMBER		18	This is to group all the accrual clearing or reversal transactions to be processed in a single run.
LATEST_CMR_AP_INVOICE_DIST_ID	NUMBER		18	Latest invoice distribution identifier in receipt accounting.
EVENT_CREATION_DATE	TIMESTAMP			Indicates event creation date in receipt accounting.
INVOICE_INTF_DATE	TIMESTAMP			This column indicates the invoice interface date for the purchase order distribution.
CMR_ACCRUAL_AMT	NUMBER			Receipt accounting accrual amount is the sum of all accounted values for accrual line type.
CMR_NR_TAX_AMT	NUMBER			Receipt accounting non-recoverable tax amount is the sum of all accounted values for accrual line type.
AP_ACCRUAL_AMT	NUMBER			Receipt accounting accrual amount for the invoice distribution.
AP_NR_TAX_AMT	NUMBER			Receipt accounting non-recoverable tax amount for the invoice distribution.
INVOICED_QTY	NUMBER			Indicates the net invoiced quantity on the purchase order distribution at the time of accrual clearing transaction.
RECEIVED_QTY	NUMBER			Indicates the total received quantity or trade quantity.
ERROR_CODE	VARCHAR2	60		Error code to indicate the error on accrual clearing transaction.
CMR_REC_TAX_AMT	NUMBER			Receipt accounting recoverable tax amount is the sum of all accounted values for accrual line type.
AP_REC_TAX_AMT	NUMBER			Receipt accounting recoverable tax amount for the invoice distribution.
INVENTORY_ITEM_ID	NUMBER		18	Inventory item identifier present in the purchase order line.
SFO_PRIMARY_TRADE_RELATION_ID	NUMBER		18	Stores the primary trade relationship identifier of an orchestration agreement line.
DESTINATION_TYPE_CODE	VARCHAR2	25		Identifies the destination type of the material. It could be either inventory or expense,
UOM_CODE	VARCHAR2	3		Unit of measure for the ordered quantity.
PO_NUMBER	VARCHAR2	40		User specified value for the purchase order.
EVENT_DATE	TIMESTAMP			This column indicates the event's happened date on the purchase order distribution.
CONSIGNED_FLAG	VARCHAR2	1		Indicates whether the item will be purchased under consignment arrangement from supplier.
PO_LINE_LOCATION_ID	NUMBER		18	This column indicates purchase order shipment schedule identifier.
CURRENCY_CODE	VARCHAR2	15		This column indicates currency of the purchase order price.
PRIMARY_LEDGER_ID	NUMBER		18	Primary ledger identifier of the business unit where journal entries are posted.
LEGAL_ENTITY_ID	NUMBER		18	This column stores the legal entity identifier of the profit center business unit.
ACCRUAL_ACCOUNT_ID	NUMBER		18	This column indicates the code combination identifier of the accrual account.
SOURCE_DOC_LINE_NUMBER	VARCHAR2	40		User specified number for the purchase order line.
SOURCE_DOC_SHIPMENT_NUMBER	VARCHAR2	40		User specified number for the purchase order shipment.
SOURCE_DOC_DISTRIB_NUMBER	VARCHAR2	40		User specified number for the purchase order distribution.
VENDOR_ID	NUMBER		18	Identifies the supplier and references to {POZ_SUPPLIERS.vendor_id}.
VENDOR_SITE_ID	NUMBER		18	Identifies the supplier site and references to {POZ_SUPPLIER_SITES_ALL_M.vendor_site_id}.
SHIP_TO_LOCATION_ID	NUMBER		18	The identifier of the specific location that the goods are being shipped.
PO_ITEM_DESCRIPTION	VARCHAR2	240		Item description specified in purchase order line. Especially needed for purchase orders involving non inventory items.
FISCAL_DOC_NUMBER	VARCHAR2	30		Number for the Fiscal Document given on the Fiscal Document sent by the supplier.
FISCAL_DOC_LINE_NUMBER	NUMBER			Indicates the line number of the Fiscal Document item line.