Table Detail Report

MM_OMF_PO



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF PO
Definition: Purchase Order Header: (Summary table)
Table Type: ACTIVITY





Column Detail - MM_OMF_PO


Column Name Type Null? Definition
BILL_TO_ADDRESS_ID DOUBLE N Address ID of the billing to address
BILL_TO_ATTN VARCHAR(40) Y Bill to Attention
BUYER_ID DOUBLE N Buyer ID of the Buyer
CLOSED_DT_NBR DOUBLE Y Closed Date Number
CLOSED_DT_TM DATETIME Y Close Date and Time
CLOSED_MIN_NBR DOUBLE Y Close Minute Number
COMMIT_DT_NBR DOUBLE Y Commit Date Number
COMMIT_DT_TM DATETIME Y Commit Date and Time
COMMIT_MIN_NBR DOUBLE Y Commit Minute Number
COMPANY_NBR VARCHAR(20) Y Company Number
CONFIRMED_BY VARCHAR(40) Y %comfirm%
CONTACT VARCHAR(40) Y Name of the person to contact
EFFECTIVE_DT_NBR DOUBLE Y Effective Date Number value
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
EFFECTIVE_MIN_NBR DOUBLE Y Effective Minute number value
EXPIRATION_DT_NBR DOUBLE Y Julian Date on which PO expires
EXPIRATION_DT_TM DATETIME Y Date on which a Purchase Order expires.
EXPIRATION_MIN_NBR DOUBLE Y Julian minute on which PO expires.
FOB_CD DOUBLE N Freight Terms Code
LAST_RECEIPT_DT_NBR DOUBLE Y Last Receipt Date Number
LAST_RECEIPT_DT_TM DATETIME Y Last Receipt Date and Time
LAST_RECEIPT_MIN_NBR DOUBLE Y Last Receipt Minute
LAST_VOUCHER_DT_NBR DOUBLE Y Last Voucher Date Number
LAST_VOUCHER_DT_TM DATETIME Y Last Voucher Date and Time
LAST_VOUCHER_MIN_NBR DOUBLE Y Last Voucher Minute
LINE_COUNT DOUBLE Y Line count under the purchase order
ORGANIZATION_ID DOUBLE N Organization ID
PO_COUNT DOUBLE Y Purchase Order Count
PO_CREATE_DT_NBR DOUBLE Y Purchase Order Create Date
PO_CREATE_DT_TM DATETIME Y Purchase Order Create Date and Time
PO_CREATE_ID DOUBLE N Purchase Order Create ID
PO_CREATE_MIN_NBR DOUBLE Y Purchase Order Create Minute
PO_NBR VARCHAR(20) Y Purchase Order Number
PO_RELEASE VARCHAR(20) Y How many times the purchase order released
PO_UPDT_CNT DOUBLE Y How may times the purchase order has been updated
PO_UPDT_DT_NBR DOUBLE Y Purchase Order Update Date
PO_UPDT_DT_TM DATETIME Y Purchase Order Update Date and Time
PO_UPDT_ID DOUBLE N Purchase Order Update ID
PO_UPDT_MIN_NBR DOUBLE Y Purchase Order Update Minute
PURCHASE_ORDER_ID DOUBLE N Purchase Order ID : (Primary Key)
PUR_PROFILE_ID DOUBLE N Purchase Order Profile ID
RECEIPT_COUNT DOUBLE Y Number of receipts under the purchase order
RECEIVE_STATUS_CD DOUBLE N Receive Status
REFERENCE VARCHAR(40) Y Reference
SHIP_TO_ADDRESS_ID DOUBLE N Ship to Address
SHIP_TO_ATTN VARCHAR(40) Y Ship to Attention (comment)
SHIP_TO_LOC_CD DOUBLE N Ship to Location Code
SHIP_VIA_CD DOUBLE N Ship Via Code
STATUS_CD DOUBLE N Status code value
TERMS_CD DOUBLE N Payment Terms Code
TOTAL_ORDER_PRICE DOUBLE Y Total Order Price
TOTAL_RECEIVED_PRICE DOUBLE Y Total Receive Price
TOTAL_VOUCHERED_PRICE DOUBLE Y Total Voucher Price
TYPE_CD DOUBLE N Purchase Order Type
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 ID
VENDOR_CD DOUBLE N Vendor associated with this account
VENDOR_SITE_ID DOUBLE N Vendor Site ID
VOUCHER_COUNT DOUBLE Y Voucher Count
VOUCHER_STATUS_CD DOUBLE N Voucher Status Code



Relationship Detail - MM_OMF_PO


Child Column in MM_OMF_PO(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_OMF_PO_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF PO LINE
Definition: PurchaseOrder line OMF table.
Table Type: ACTIVITY





Column Detail - MM_OMF_PO_LINE


Column Name Type Null? Definition
BASE_BACKORDER_QTY DOUBLE Y base back order quantity
BASE_CANCEL_QTY DOUBLE Y Base Cancel Quantity
BASE_INVOICE_QTY DOUBLE Y Base Invoice Quantity
BASE_ORDER_QTY DOUBLE Y Base Order Quantity
BASE_PRICE DOUBLE Y Base Package Type Price
BASE_RECEIPT_QTY DOUBLE Y Base Receipt Quantity
BUYER_ID DOUBLE N Buyer ID of the Buyer
CNTRCT_BEG_EFF_DT_NBR DOUBLE Y Contract Begin Effective Date Number
CNTRCT_BEG_EFF_DT_TM DATETIME Y Contract Begin Effective Date time
CNTRCT_BEG_EFF_MIN_NBR DOUBLE Y Contract Begin Effective minute number
CNTRCT_END_EFF_DT_NBR DOUBLE Y Contract end Effective date number
CNTRCT_END_EFF_DT_TM DATETIME Y Contract end Effective date time
CNTRCT_END_EFF_MIN_NBR DOUBLE Y Contract end Effective minute number
CNTRCT_ID DOUBLE N Contract number key
CNTRCT_NBR VARCHAR(40) Y Contract number
CNTRCT_TYPE_CD DOUBLE N Contract type code value
COMPANY_NBR VARCHAR(20) Y Company Number
CONTRACT_DESC VARCHAR(100) Y Contract Description
CONTRACT_IND DOUBLE Y Contract Indicator
COST_CENTER_CD DOUBLE N Cost center code value
DELIVER_TO_LOC_CD DOUBLE N Deliver to location
DSL_IM_ORDER DOUBLE Y Days since last item master ordered
DSL_IM_RECEIPT DOUBLE Y Days since last item master receipt
DSL_VI_ORDER DOUBLE Y Days since last vendor item order
DSL_VI_RECEIPT DOUBLE Y Days since last vendor item receipt
ITEM_BASE_PKG_DESC VARCHAR(40) Y Item Master Base Pkg type description
ITEM_BASE_PKG_ID DOUBLE N Foreign Key to package type table
ITEM_BASE_PKG_QTY DOUBLE Y Base Pkg Type Quantity
ITEM_BASE_PKG_UOM_CD DOUBLE N Base Pkg Unit Of Measure Code
ITEM_MASTER_ID DOUBLE N Foreign Key to Item Master Table
ITEM_SUB_ACCOUNT_CD DOUBLE N Sub Account
LAST_RECEIPT_DT_NBR DOUBLE Y Last Receipt Date Nbr
LAST_RECEIPT_DT_TM DATETIME Y Last Receipt Date Time
LAST_RECEIPT_MIN_NBR DOUBLE Y Last Receipt Min Nbr
LAST_VOUCHER_DT_NBR DOUBLE Y Last Voucher Date/Time Nbr
LAST_VOUCHER_DT_TM DATETIME Y Last Voucher Date/Time
LAST_VOUCHER_MIN_NBR DOUBLE Y Last Voucher Min Nbr
LINE_COUNT DOUBLE Y Line Count
LINE_CREATE_BUYER_ID DOUBLE N Line Create Buyer ID
LINE_CREATE_DT_NBR DOUBLE Y Line Create Date Nbr
LINE_CREATE_DT_TM DATETIME Y Line Create Date/Time
LINE_CREATE_MIN_NBR DOUBLE Y Line Create Min Nbr
LINE_ITEM_ID DOUBLE N Line Item ID : Primary Key
LINE_NBR DOUBLE Y Line Number
LINE_STATUS_CD DOUBLE N Line Status
LINE_UPDT_BUYER_ID DOUBLE N Update Buyer ID
LINE_UPDT_DT_NBR DOUBLE Y Line Update Nbr
LINE_UPDT_DT_TM DATETIME Y Line Update Date/Time
LINE_UPDT_MIN_NBR DOUBLE Y Line Update Min Nbr
MFG_CD DOUBLE N Manufacturer
MFG_ITEM_ID DOUBLE N Foreign Key to Manufacturer Item
NC_DESCRIPTION VARCHAR(255) Y Non-catalog description
NC_MFR VARCHAR(60) Y Non-catalog manufacturer
NC_MFR_CD DOUBLE N If the non-catalog manufacturer exists in our current system. This is the code value for the corresponding manufacturer.
NC_MFR_ITEM_NBR VARCHAR(20) Y Non-catalog manufacturer item number
NC_VENDOR_ITEM_NBR VARCHAR(20) Y Non-catalog vendor item number
NON_CATALOG_IND DOUBLE Y Indicator used to determine if the line is a non-catalog item
ORDER_PKG_DESC VARCHAR(40) Y Order Pkg Description
ORDER_PKG_ID DOUBLE N Foreign Key to Package_Type Table
ORDER_PKG_QTY DOUBLE Y Order Pkg Quantity
ORDER_PKG_UOM_CD DOUBLE N Order Pkg UOM
ORDER_PRICE DOUBLE Y Order Price
ORDER_PRICE_TYPE_CD DOUBLE N Order Price Type
ORDER_QTY DOUBLE Y Order Quantity
ORGANIZATION_ID DOUBLE N Foreign Key to Organization Table
PO_CLOSED_DT_NBR DOUBLE Y Closed date nbr
PO_CLOSED_DT_TM DATETIME Y closed date/time
PO_CLOSED_MIN_NBR DOUBLE Y closed min nbr
PO_COMMIT_DT_NBR DOUBLE Y commit date nbr
PO_COMMIT_DT_TM DATETIME Y commit date/time
PO_COMMIT_MIN_NBR DOUBLE Y commit min nbr
PO_CREATE_DT_NBR DOUBLE Y create date nbr
PO_CREATE_DT_TM DATETIME Y create date/time
PO_CREATE_MIN_NBR DOUBLE Y create min nbr
PO_EFFECTIVE_DT_NBR DOUBLE Y effective date nbr
PO_EFFECTIVE_DT_TM DATETIME Y effective date/time
PO_EFFECTIVE_MIN_NBR DOUBLE Y effective min nbr
PO_NBR VARCHAR(20) Y PO Nbr.
PO_STATUS_CD DOUBLE N PO Status
PO_TYPE_CD DOUBLE N PO Type
PO_UPDT_DT_NBR DOUBLE Y Update Nbr
PO_UPDT_DT_TM DATETIME Y Update Date/Time
PO_UPDT_MIN_NBR DOUBLE Y Update Min Nbr
PURCHASE_ORDER_ID DOUBLE N Foreign Key to PurchaseOrder Table
RECEIVE_STATUS_CD DOUBLE N Receipt Status
SHIP_TO_LOC_CD DOUBLE N Ship To Location
SUBSTITUTION_IND DOUBLE Y Indicator used to see if the item is being substituted.
SUB_ACCOUNT_CD DOUBLE N Sub Account
UNIT_TAX DOUBLE N Unit Tax for the purchase Order line item.
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 Vendor associated with this account
VENDOR_ITEM_ID DOUBLE N Foreign Key for the Vendor Item
VOUCHER_STATUS_CD DOUBLE N Voucher Status



Relationship Detail - MM_OMF_PO_LINE


Child Column in MM_OMF_PO_LINE(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_OMF_RECEIPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF RECEIPT
Definition: Receipt : (Summary Table)
Table Type: ACTIVITY





Column Detail - MM_OMF_RECEIPT


Column Name Type Null? Definition
BILL_TO_ADDRESS_ID DOUBLE N Address ID of the Bill to Address
BILL_TO_ATTN VARCHAR(40) Y Bill to Attention
BUYER_ID DOUBLE N Buyer ID of the Buyer
COMMIT_DT_NBR DOUBLE Y Commit Date
COMMIT_DT_TM DATETIME Y Commit Date and Time
COMMIT_MIN_NBR DOUBLE Y Commit Minute
COMPANY_NBR VARCHAR(20) Y Company Number
CONFIRMED_BY VARCHAR(40) Y %comfirm%
CONTACT VARCHAR(40) Y The person to contact
EFFECTIVE_DT_NBR DOUBLE Y Effective Date Number value
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
EFFECTIVE_MIN_NBR DOUBLE Y Effective Minute number value
FOB_CD DOUBLE N Freight Terms Code
LAST_VOUCHER_DT_NBR DOUBLE Y Last voucher date
LAST_VOUCHER_DT_TM DATETIME Y Last Voucher Date and Time
LAST_VOUCHER_MIN_NBR DOUBLE Y Last Voucher Minute
ORDER_DT_NBR DOUBLE Y Order Date Number value
ORDER_DT_TM DATETIME Y Order Date and Time value
ORDER_MIN_NBR DOUBLE Y Order Minute
ORGANIZATION_ID DOUBLE N Organization ID
PACK_SLIP_NBR VARCHAR(40) Y Pack Slip Number
PO_EFFECTIVE_DT_NBR DOUBLE Y %Puchase%
PO_EFFECTIVE_DT_TM DATETIME Y %Puchase%
PO_EFFECTIVE_MIN_NBR DOUBLE Y %Puchase%
PO_NBR VARCHAR(20) Y Purchase Order Number
PO_RCV_STATUS_CD DOUBLE N Purchase Order Receive Status Code
PO_STATUS_CD DOUBLE N Purchase Order Status Code
PO_TYPE_CD DOUBLE N Purchase Order Type Code
PURCHASE_ORDER_ID DOUBLE N Purchase Order ID
RECEIPT_COUNT DOUBLE Y Receipt Count
RECEIPT_ID DOUBLE N Receipt ID : (Primary Key).
RECEIPT_LINE_COUNT DOUBLE Y Receipt Line Count
RECEIVE_DT_NBR DOUBLE Y Receive Date
RECEIVE_DT_TM DATETIME Y Receive Date and Time
RECEIVE_LOCATION_CD DOUBLE N Receive Location Code
RECEIVE_MIN_NBR DOUBLE Y Receive Minute
REFERENCE VARCHAR(40) Y Reference
SEQUENCE DOUBLE Y Sequence value
SHIP_TO_ADDRESS_ID DOUBLE N Ship to Address ID
SHIP_TO_ATTN VARCHAR(40) Y Ship to Attention
STATUS_CD DOUBLE N Receipt Status Code
TOTAL_ORDER_PRICE DOUBLE Y Total Order Price
TOTAL_RECEIVE_PRICE DOUBLE Y Total Receive Price
TOTAL_VOUCHER_PRICE DOUBLE Y Total Voucher Price
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 Vendor associated with this account
VOUCHER_COUNT DOUBLE Y Voucher Count



Relationship Detail - MM_OMF_RECEIPT


Child Column in MM_OMF_RECEIPT(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_OMF_RECEIPT_LINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF RECEIPT LINE
Definition: Receipt Line : (Summary Table)
Table Type: ACTIVITY





Column Detail - MM_OMF_RECEIPT_LINE


Column Name Type Null? Definition
ACTUAL_ITEM_ID DOUBLE N System Generated Item ID
ACTUAL_MFG_ITEM_ID DOUBLE N Actual Manufacturer Item ID
ACTUAL_VENDOR_ITEM_ID DOUBLE N Actual Vendor Item ID
BASE_ACCEPTED_QTY DOUBLE Y Based Accepted Quantity
BASE_BACK_ORDER_QTY DOUBLE Y Base Back Order Quantity
BASE_CANCEL_QTY DOUBLE Y Base Cancel Quantity
BASE_INVOICE_QTY DOUBLE Y Base Invoice Quantity
BASE_ORDER_QTY DOUBLE Y Base Order Quantity
BASE_PRICE DOUBLE Y Base Price
BASE_RECEIPT_QTY DOUBLE Y Base Receipt Quantity
COMPANY_NBR VARCHAR(20) Y Company Number
DELIVER_TO_LOCATION_CD DOUBLE N Deliver to Location Code
EXTENDED_PRICE DOUBLE Y Extended Price
FROM_COST_CENTER_CD DOUBLE N From Cost Center Code
FROM_SUB_ACCOUNT_CD DOUBLE N From Sub Account Code
INVOICE_COUNT DOUBLE Y Invoice Count
ITEM_MASTER_ID DOUBLE N Item Master ID
LINE_COUNT DOUBLE Y Line Count
LINE_CREATE_DT_NBR DOUBLE Y Line Create Date
LINE_CREATE_DT_TM DATETIME Y Line Create Date and Time
LINE_CREATE_ID DOUBLE N Line Create ID
LINE_CREATE_MIN_NBR DOUBLE Y Line Create Minute
LINE_ITEM_ID DOUBLE N Line Item ID : Primary Key
LINE_UPDT_DT_NBR DOUBLE Y Line Update Date
LINE_UPDT_DT_TM DATETIME Y Line Update Date and Time
LINE_UPDT_ID DOUBLE N Line Update ID
LINE_UPDT_MIN_NBR DOUBLE Y Line Update Minute
MFG_ITEM_ID DOUBLE N Foreign Key to Manufacturer Item
NC_855_IND DOUBLE Y When the non catalog item is created from the EDI workflow, stores the indicator as 1
NC_DESCRIPTION VARCHAR(255) Y Non-catalog description
NC_MFR VARCHAR(60) Y Non-catalog manufacturer
NC_MFR_CD DOUBLE N If the non-catalog manufacturer exists in our current system. This is the code
NC_MFR_ITEM_NBR VARCHAR(20) Y Non-catalog manufacturer item number
NC_NDC_VALUE VARCHAR(50) Y Stores the NDC value for the non catalog item. This field will be set to 1 when the T3 data exists for a receipt line.
NC_VENDOR_ITEM_NBR VARCHAR(20) Y Non-catalog vendor item number
NON_CATALOG_IND DOUBLE Y Indicator used to determine if the line is a non-catalog item
ORDER_DT_NBR DOUBLE Y Order Date Number value
ORDER_DT_TM DATETIME Y Order Date and Time value
ORDER_MIN_NBR DOUBLE Y Order Minute
ORDER_PERSON_ID DOUBLE N Order Person ID
ORDER_PKG_DESC VARCHAR(40) Y Order Package Type Description
ORDER_PKG_ID DOUBLE N Order Package ID
ORDER_PKG_QTY DOUBLE Y Order Package Quantity
ORDER_PKG_UOM_CD DOUBLE N Order Package Unit of Measure Code
ORDER_PRICE DOUBLE Y Order Price
ORDER_PRICE_TYPE_CD DOUBLE N Order Price Type Code
ORDER_QTY DOUBLE Y Order Quantity
ORGANIZATION_ID DOUBLE N Organization ID
PO_EFFECTIVE_DT_NBR DOUBLE Y Purchase Order Effective Date
PO_EFFECTIVE_DT_TM DATETIME Y Purchase Order Effective Date and Time
PO_EFFECTIVE_MIN_NBR DOUBLE Y Purchase Order Effective Minute
PO_LINE_NBR DOUBLE Y Purchase Order Line Number
PO_NBR VARCHAR(20) Y Purchase Order Number
PO_RCV_STATUS_CD DOUBLE N Purchase Order Receive Status Code
PO_STATUS_CD DOUBLE N Purchase Order Status Code
PURCHASE_ORDER_ID DOUBLE N Purchase Order ID
RCV_EFFECTIVE_DT_NBR DOUBLE Y Receive Effective Date
RCV_EFFECTIVE_DT_TM DATETIME Y Receive Effective Date and Time
RCV_EFFECTIVE_MIN_NBR DOUBLE Y Receive Effective Minute
RECEIPT_ID DOUBLE N Receipt ID
RECEIPT_LINE_ITEM_ID DOUBLE N Receipt Line Item ID : (Primary Key)
RECEIPT_PKG_DESC VARCHAR(40) Y Receipt Package Description
RECEIPT_PKG_ID DOUBLE N Receipt Package ID
RECEIPT_PKG_QTY DOUBLE Y Receipt Package Quantity
RECEIPT_PKG_UOM_CD DOUBLE N Receipt Package Unit of Measure
RECEIPT_PRICE DOUBLE Y Receipt Price
RECEIPT_QTY DOUBLE Y Receipt Quantity
SUBSTITUTION_IND DOUBLE Y Indicator used to see if the item is being substituted.
TO_COST_CENTER_CD DOUBLE N To Cost Center Code
TO_SUB_ACCOUNT_CD DOUBLE N To Sub Account Code
UNIT_TAX DOUBLE N Unit Tax for the PO Receipt line item.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENDOR_ITEM_ID DOUBLE N Foreign Key for the Vendor Item



Relationship Detail - MM_OMF_RECEIPT_LINE


Child Column in MM_OMF_RECEIPT_LINE(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_PAYMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: mm payment
Definition: Payment reference table that will store payment transactions
Table Type: ACTIVITY





Column Detail - MM_PAYMENT


Column Name Type Null? Definition
AMOUNT DOUBLE Y Payment amount
CHECK_NBR VARCHAR(40) Y check number
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 User id of person which created this row
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
FOREIGN_VOUCHER_NBR VARCHAR(40) Y foreign voucher number
MM_PAYMENT_COMMENT VARCHAR(255) Y %payement%
MM_PAYMENT_ID DOUBLE N mm payment identifier
PAYMENT_DT_TM DATETIME Y payment date and time
PAYMENT_METHOD VARCHAR(60) Y payment method
PAYMENT_TYPE VARCHAR(60) Y PAYMENT TYPE
PRSNL_NAME VARCHAR(100) Y personnel name
PURCHASE_ORDER_ID DOUBLE N purchase order identifier
REFERENCE_NBR VARCHAR(60) Y reference number
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 - MM_PAYMENT


Child Column in MM_PAYMENT(FK) Parent Table Name Parent Column Name
Parents: PURCHASE_ORDER_ID PURCHASE_ORDER PURCHASE_ORDER_ID