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