Oracle E-Business Suite · Schema
DiscreteJob
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| wipEntityId | integer | WIP entity identifier |
| wipEntityName | string | Job name/number |
| organizationId | integer | Organization identifier |
| primaryItemId | integer | Primary assembly item identifier |
| primaryItemNumber | string | Primary assembly item number |
| statusType | integer | Job status (1=Unreleased, 3=Released, 4=Complete, 5=Complete-No Charges, 6=On Hold, 7=Cancelled, 12=Closed, 14=Pending Close, 15=Failed Close) |
| jobType | integer | Job type (1=Standard, 3=Non-Standard) |
| startQuantity | number | Start quantity |
| quantityCompleted | number | Quantity completed |
| quantityScrapped | number | Quantity scrapped |
| netQuantity | number | Net quantity remaining |
| scheduledStartDate | string | Scheduled start date |
| scheduledCompletionDate | string | Scheduled completion date |
| dateReleased | string | Date released |
| dateCompleted | string | Date completed |
| dateClosed | string | Date closed |
| classCode | string | Accounting class code |
| bomRevision | string | BOM revision |
| routingRevision | string | Routing revision |
| description | string | Job description |
| firmPlannedFlag | integer | Firm planned flag (1=Firm, 2=Not Firm) |
| creationDate | string | |
| lastUpdateDate | string |