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 |