Purchase Order |
EntityType | Independent |
Logical Entity Name | Purchase Order |
Default Table Name | PO |
Logical Only | NO |
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 |
Purchase Order Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Purchase Order Number | Purchase Order Number | VARCHAR(20) | NO | |
Purchase Order Item Number | INTEGER | NO | ||
Description | Description | VARCHAR(255) | YES | Description: Often used in validation tables accompanying an abbreviated identifer. |
Purchase Order Item Quantity | INTEGER | YES | ||
Purchase Request Number | Purchase Request Number | VARCHAR(25) | NO | |
Purchase Request Item Number | INTEGER | YES | ||
Technical Project Officer Badge Number | Badge Number | VARCHAR(10) | YES | |
Goods Recipient Badge Number | Badge Number | VARCHAR(10) | YES | |
Building Identifier | Building | VARCHAR(10) | YES | Building: The building number. |
Location | VARCHAR(100) | YES | ||
Modify Date | Modify Date | DATE | NO | Modify Date: The date the entity values were were created or modified. |
Closed Indicator | Indicator | CHAR(1) | NO |
Purchase Order Keys |
Key Name | Key Type | Keys |
PK_PO | PrimaryKey | Purchase Order Number, Purchase Order Item Number |
Purchase Order Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Purchase Order Item Receipt | Identifying | One To Zero or More | NO | ||||
Purchase Order History | Identifying | One To Zero or More | NO |
Purchase Order Check Constraints |
Check Constraint Name | CheckConstraint |
Purchase Order Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Purchase Order Security Types |
Name | Current Value |
Purchase Order Bound Attachments |
Name | Current Value |
Purchase Order 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 |
Purchase Order Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Inventory Control |
INVT (Oracle) | Main Model |
Purchase Order Data Movement Rules |
Name | Type | Rule Text/Value |