Table Detail Report
PO_BATCH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PO Batch |
Definition: | This is a holding table for outbound purchase orders. |
Table Type: | ACTIVITY |
Column Detail - PO_BATCH
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_APPLCTX | DOUBLE | Y | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | Y | The date and time the row was inserted. |
CREATE_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table. |
CREATE_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted the row. |
PO_BATCH_ID | DOUBLE | N | Primary Key |
TRANSMIT_DT_TM | DATETIME | Y | Transmit Date and Time |
TRANSMIT_FLAG | DOUBLE | Y | Transmit Flag is used to recognize whether the po's are transmitted or not. |
TRANSMIT_STATUS_CD | DOUBLE | Y | Transmit_Status_CD |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VENDOR_CD | DOUBLE | N | The vendor for which this batch was created. |
VENDOR_SITE_ID | DOUBLE | N | The vendor account. |
Relationship Detail - PO_BATCH
Child Column in PO_BATCH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | VENDOR_SITE_ID | VENDOR_SITE | VENDOR_SITE_ID |
PO_BATCH_ENTRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Holding table for outbound purchase orders. |
Definition: | PO Batch Entry |
Table Type: | ACTIVITY |
Column Detail - PO_BATCH_ENTRY
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_APPLCTX | DOUBLE | Y | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | Y | The date and time the row was inserted. |
CREATE_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table. |
CREATE_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted the row. |
PO_BATCH_ID | DOUBLE | N | Foreign key to po_batch table. |
PURCHASE_ORDER_ID | DOUBLE | N | Foreign key to purchase order table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - PO_BATCH_ENTRY
Child Column in PO_BATCH_ENTRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PURCHASE_ORDER_ID | PURCHASE_ORDER | PURCHASE_ORDER_ID |
PO_NUMBER_SEED
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PO NUMBER SEED |
Definition: | Holds information on automatically generating po numbers. |
Table Type: | REFERENCE |
Column Detail - PO_NUMBER_SEED
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_SEQ | DOUBLE | Y | The beginning of the range of sequences. |
CREATE_APPLCTX | DOUBLE | N | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | N | The date and time the row was was inserted. |
CREATE_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table. |
CREATE_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted the row. |
DESCRIPTION | VARCHAR(100) | Y | The description of this seed. |
END_SEQ | DOUBLE | Y | The end of the range of sequences. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MANUAL_IND | DOUBLE | Y | Indicates whether or not the numbers are generated manually. |
PO_NUMBER_SEED_ID | DOUBLE | N | Primary Key |
PREFIX | CHAR(10) | Y | A string that will be added onto the front of all generate numbers. |
SEED_SEQ | DOUBLE | Y | The next sequence number to use. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - PO_NUMBER_SEED
Child Column in PO_NUMBER_SEED(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
PO_RECEIPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PO RECEIPT |
Definition: | Stores inventory purchase order receipt header information. |
Table Type: | ACTIVITY |
Column Detail - PO_RECEIPT
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMIT_DT_TM | DATETIME | Y | The date that the receipt was committed. |
CREATE_APPLCTX | DOUBLE | N | The application context number from the record info block. |
CREATE_DT_TM | DATETIME | N | The date and time the row was inserted. |
CREATE_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table. |
CREATE_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted the row. |
EFFECTIVE_DT_TM | DATETIME | Y | The date and time that the receipt becomes effective. |
INVOICE_NBR | VARCHAR(40) | Y | The reference number assigned to a purchase order by the vendor for tracking and payment. |
MATCHED_STATUS_CD | DOUBLE | Y | The voucher status for the receipt. The values are: Unmatched, In Process, and Matched. |
OMF_SUCCESS_IND | DOUBLE | N | The value of 0 or 1 indicates the success or failure of the respective OMF table update. 1 indicates update to OMF table was successful and 0 indicates failure. |
PACK_SLIP_NBR | VARCHAR(40) | Y | The reference number assigned by a vendor to a shipment. |
PERSON_ID | DOUBLE | Y | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PO_RECEIPT_ID | DOUBLE | N | The identifier assigned to the purchase order receipt. |
PURCHASE_ORDER_ID | DOUBLE | Y | The identifier of the purchase order for which the receipt is created. |
RECEIVE_DT_TM | DATETIME | Y | Actual date and time shipment was received. |
RECEIVE_LOCATION_CD | DOUBLE | Y | Location where the physical receiving of the purchase order was performed. |
SEQUENCE | DOUBLE | Y | The received shipment order for the purchase order. The first shipment received for a purchase order is assigned one (1), the second two(2), etc.,. |
STATUS_CD | DOUBLE | N | The status assigned to the purchase order receipt. The valid values are Open and Closed. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VENDOR_CD | DOUBLE | Y | The vendor from which the purchase order receipt is received. |
Relationship Detail - PO_RECEIPT
Child Column in PO_RECEIPT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PURCHASE_ORDER_ID | PURCHASE_ORDER | PURCHASE_ORDER_ID |
Parent Column in PO_RECEIPT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PO_RECEIPT_ID | INVOICE_PO_RECEIPT_R | PO_RECEIPT_ID |
MM_TRANS_HEADER | PO_RECEIPT_ID | ||
RECEIPT_LINE_ITEM | PO_RECEIPT_ID |
PURCHASE_ORDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Purchase Order |
Definition: | Purchase orders. |
Table Type: | ACTIVITY |
Column Detail - PURCHASE_ORDER
Column Name | Type | Null? | Definition |
---|---|---|---|
ACK_DT_TM | DATETIME | Y | The date/Time the purchase order was acknowledged by the vendor. |
BILL_TO_ADDRESS_ID | DOUBLE | N | The billing address |
BILL_TO_ATTN | VARCHAR(100) | Y | Free text field to enter billing attention information |
BILL_TO_PSR_CD | DOUBLE | N | Bill to purchasing service resource |
BUYER_ID | DOUBLE | N | This denotes the buyer that is assigned to the purchase order. |
CLOSED_DT_TM | DATETIME | Y | The date/time the purchase order was closed. |
COMMIT_DT_TM | DATETIME | Y | The date and time the purchase order was committed. |
COMMUNICATION_DT_TM | DATETIME | Y | The date/time the purchase order was communicated electronically |
COMMUNICATION_STATUS_CD | DOUBLE | N | The status of the communication |
COMMUNICATION_TYPE_CD | DOUBLE | N | The type of communication utilized |
CONFIRMED_BY | VARCHAR(100) | Y | Free text field to capture who confirmed the message. |
CONTACT | VARCHAR(100) | Y | Free text field to capture contact information |
CREATE_APPLCTX | DOUBLE | N | Application which created this row |
CREATE_DT_TM | DATETIME | N | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_TASK | DOUBLE | Y | Task which created this row |
EFFECTIVE_DT_TM | DATETIME | Y | Effective Date and Time value |
EXPIRATION_DT_TM | DATETIME | Y | Date on which a Purchase Order expires. |
FOB_CD | DOUBLE | N | Freight Term |
OMF_SUCCESS_IND | DOUBLE | N | The value of 0 or 1 indicates the success or failure of the respective OMF table update. 1 indicates update to OMF table was successful and 0 indicates failure. |
ORGANIZATION_ID | DOUBLE | N | The organization for which this po was created. |
PHASE_INVOICE_IND | DOUBLE | Y | |
PO_NBR | VARCHAR(40) | Y | Purchase Order Number |
PO_NBR_KEY | VARCHAR(40) | N | Purchase Order Number |
PO_NBR_KEY_A_NLS | VARCHAR(160) | Y | PO_NBR_KEY_A_NLS column |
PO_NBR_KEY_NLS | VARCHAR(82) | Y | The user or system assigned purchase order number |
PO_RELEASE | VARCHAR(40) | Y | |
PO_SEED_IND | DOUBLE | Y | Indicates where the purchase order number was generated or user defined. |
PO_TYPE_CD | DOUBLE | N | Indicates the type of purchase order created. |
PURCHASE_ORDER_ID | DOUBLE | N | Primary key |
PUR_PROFILE_ID | DOUBLE | N | The purchasing profile that was used to create the po. |
RCV_LOCATION_CD | DOUBLE | N | The location which the po will be received. |
RCV_PROFILE_ID | DOUBLE | N | Obsolete |
RECEIVE_STATUS_CD | DOUBLE | N | The status of the receipts |
RECV_WORKSHEET_PRINT_DT_TM | DATETIME | Y | The date/time the receiving worksheet was last printed |
REFERENCE | VARCHAR(40) | Y | Free text reference field |
RUSH_IND | DOUBLE | N | Used to determine if the purchase order has been flagged as a rush order. |
SHIP_TO_ADDRESS_ID | DOUBLE | N | The address the purchase order will be shipped too |
SHIP_TO_ATTN | VARCHAR(100) | Y | Free text field to enter ship to attention information |
SHIP_TO_PSR_CD | DOUBLE | N | Ship to purchasing service resource |
SHIP_VIA_CD | DOUBLE | N | Method the purchase order will be shipped |
STATUS_CD | DOUBLE | N | The status of the purchase order |
TAX_EXEMPT_IND | DOUBLE | N | Indicates whether the PO was created for a tax-exempt vendor. |
TEMPLATE_ID | DOUBLE | N | |
TERMS_CD | DOUBLE | N | Payment Terms |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VENDOR_ADDRESS_ID | DOUBLE | N | Vendor Address |
VENDOR_CD | DOUBLE | N | Vendor associated with this account |
VENDOR_SITE_ID | DOUBLE | N | Foreign key to vendor_site table. |
VOUCHER_STATUS_CD | DOUBLE | N | The status of the invoice voucher |
Relationship Detail - PURCHASE_ORDER
Child Column in PURCHASE_ORDER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILL_TO_ADDRESS_ID | ADDRESS | ADDRESS_ID |
SHIP_TO_ADDRESS_ID | ADDRESS | ADDRESS_ID | |
VENDOR_ADDRESS_ID | ADDRESS | ADDRESS_ID | |
PUR_PROFILE_ID | MM_PROFILE | PROFILE_ID | |
RCV_PROFILE_ID | MM_PROFILE | PROFILE_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
VENDOR_SITE_ID | VENDOR_SITE | VENDOR_SITE_ID |
Parent Column in PURCHASE_ORDER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PURCHASE_ORDER_ID | INVOICE | PURCHASE_ORDER_ID |
MM_AP_LOG_LINE_HMW | PURCHASE_ORDER_ID | ||
MM_PAYMENT | PURCHASE_ORDER_ID | ||
MM_RECEIPT_DOC_HEADER | PURCHASE_ORDER_ID | ||
MM_TRANS_HEADER | PURCHASE_ORDER_ID | ||
MM_XFI_CNTRCT_HDR | PO_ID | ||
MM_XFI_PAYMENT | PURCHASE_ORDER_ID | ||
PO_BATCH_ENTRY | PURCHASE_ORDER_ID | ||
PO_RECEIPT | PURCHASE_ORDER_ID |