PO |
Logical Entity Name | Purchase Order |
Default Table Name | PO |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | INVT |
Definition | Purchase Order: NScD personnel will have the option on a purchase request to indicate that that one or more line items will fall under inventory control. Once the purchase order is released SAP will send the PO information to IC through a Web Services call. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE INVT.PO(      PO_NBR                VARCHAR2(20)      NOT NULL,      PO_ITEM_NBR           NUMBER(38, 0)     NOT NULL,      DESCR                 VARCHAR2(255),      PO_ITEM_QTY           NUMBER(38, 0),      PR_NBR                VARCHAR2(25)      NOT NULL,      PR_ITEM_NBR           NUMBER(38, 0),      TPO_BN                VARCHAR2(10),      GOOD_RECPT_BN         VARCHAR2(10),      GOOD_REC_NBR          NUMBER(38, 0),      GOOD_REC_ITEM_NBR     NUMBER(38, 0),      BLDG_ID               VARCHAR2(10),      LOC                   VARCHAR2(100),      QTY_RECD_NBR          NUMBER(38, 0),      RECD_DTE              DATE              DEFAULT sysdate NOT NULL,      DEVLIV_BN             VARCHAR2(10),      MOD_DATE              DATE              NOT NULL,      CONSTRAINT PK_PO PRIMARY KEY (PO_NBR, PO_ITEM_NBR)      USING INDEX          LOGGING ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
PO Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PO_NBR | Purchase Order Number | VARCHAR2(20) | NO | |
PO_ITEM_NBR | NUMBER(38, 0) | NO | ||
DESCR | Description | VARCHAR2(255) | YES | Description: Often used in validation tables accompanying an abbreviated identifer. |
PO_ITEM_QTY | NUMBER(38, 0) | YES | ||
PR_NBR | Purchase Request Number | VARCHAR2(25) | NO | |
PR_ITEM_NBR | NUMBER(38, 0) | YES | ||
TPO_BN | Badge Number | VARCHAR2(10) | YES | |
GOOD_RECPT_BN | Badge Number | VARCHAR2(10) | YES | |
GOOD_REC_NBR | NUMBER(38, 0) | YES | ||
GOOD_REC_ITEM_NBR | NUMBER(38, 0) | YES | ||
BLDG_ID | Building | VARCHAR2(10) | YES | Building: The building number. |
LOC | VARCHAR2(100) | YES | ||
QTY_RECD_NBR | NUMBER(38, 0) | YES | ||
RECD_DTE | Date | DATE | NO | Date: Date and time to seconds. |
DEVLIV_BN | Badge Number | VARCHAR2(10) | YES | Delivery Badge Number: The person who delivered the IC item. |
MOD_DATE | Modify Date | DATE | NO | Modify Date: The date the entity values were were created or modified. |
PO Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_PO | PrimaryKey | PO_NBR, PO_ITEM_NBR |
PO Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
PO_HIST | Identifying | One To Zero or More | fk_po_hist_to_po | NO | NO | NO |
PO Check Constraints |
Check Constraint Name | CheckConstraint |
PO Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Row Movement | Disabled |
PO Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PO Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
PO Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
PO Security Types |
Name | Current Value |
PO Bound Attachments |
Name | Current Value |
PO Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical INVT.Purchase Order |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) INVT.PO |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
PO Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Inventory Control |
INVT (Oracle) | Main Model |
PO Data Movement Rules |
Name | Type | Rule Text/Value |