CST_RECEIPTS_GT
Receipts Available to Deplete - quantity onhand
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
CST_RECEIPTS_GT_PK |
REC_TRXN_ID |
Columns
| Name |
|---|
|
REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.Active REC_TRXN_IDNUMBER18YesReceipt Transaction IdentifyerActive COST_ORG_IDNUMBER18YesSingle column FK: Identifies the Cost Organization associated with the inventory organization.Active COST_BOOK_IDNUMBER18YesSingle column FK: Identifies the Cost Book assigned to the Cost Organization.Active VAL_UNIT_IDNUMBER18Valuation unit identifierActive INVENTORY_ITEM_IDNUMBER18YesInventory Item IdentifierActive COST_DATETIMESTAMPTransaciton Cost DateActive QUANTITY_ONHANDNUMBERQuantity Onhand To DepleteActive |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_RECEIPTS_GT_U1 | Unique | REC_TRXN_ID |