CST_COST_DISTS_GT

Temporary table used within distribution processor to generate the distribution header information.

Details

Name
DISTRIBUTION_IDNUMBER18Single column FK: Identifies the cost distribution header record. TRANSACTION_IDNUMBER18Reference to the transaction for which the distribution is created. REC_TRXN_IDNUMBER18Reference to the receipt layer for which the distribution is created. DEP_TRXN_IDNUMBER18Reference to the depletion layer for which the distribution is created. ADDITIONAL_PROCESSING_CODEVARCHAR220For PO Receipt deliveries, different events will be created for different cost sources EFF_DATETIMESTAMPEffective Date of transaction. EVENT_TYPE_CODEVARCHAR230Reference to the Event type of the event for the distribution.

Name

DISTRIBUTION_IDNUMBER18Single column FK: Identifies the cost distribution header record.

TRANSACTION_IDNUMBER18Reference to the transaction for which the distribution is created.

REC_TRXN_IDNUMBER18Reference to the receipt layer for which the distribution is created.

DEP_TRXN_IDNUMBER18Reference to the depletion layer for which the distribution is created.

ADDITIONAL_PROCESSING_CODEVARCHAR220For PO Receipt deliveries, different events will be created for different cost sources

EFF_DATETIMESTAMPEffective Date of transaction.

EVENT_TYPE_CODEVARCHAR230Reference to the Event type of the event for the distribution.

Index	Uniqueness	Columns
CST_COST_DISTS_GT_N1	Non Unique	TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID, ADDITIONAL_PROCESSING_CODE, EVENT_TYPE_CODE