ADDITIONAL_AMOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ADDITIONAL AMOUNT
Definition: ADDITIONAL AMOUNT Table
Table Type: ACTIVITY





Column Detail - ADDITIONAL_AMOUNT


Column Name Type Null? Definition
ADDITIONAL_AMOUNT_ID DOUBLE N The identifier assigned to the purchase order additional amount.
ADDITIONAL_AMOUNT_TYPE_CD DOUBLE N The code associated with the additional amount type. This might include Tax, Freight, Service Charges, VAT Tax, Deposit, Credit and so forth.
COST_CENTER_CD DOUBLE N The General Ledger Cost Center where this transaction will be charged.
CREATE_APPLCTX DOUBLE N Creating Application Context
CREATE_DT_TM DATETIME N Created Date Time
CREATE_ID DOUBLE N Creator ID
CREATE_TASK DOUBLE Y Creating Task
DOLLAR_AMOUNT DOUBLE Y The dollar amount to be charged in association with this additional amount code.
MATCHED_IND DOUBLE Y Indicates if this additional amount has already been "matched" tp a purchase order.
MM_PROJECT_NBR_TRACKING_ID DOUBLE N Link to the project used for the budget.
PARENT_ENTITY_ID DOUBLE N Parent Entity Table ID value
PARENT_ENTITY_NAME VARCHAR(40) N The name of the parent entity (table)
REFERENCE VARCHAR(40) Y Reference Text
SUB_ACCOUNT_CD DOUBLE N The general ledger sub account code or expense category that this additional amount will be charged to.
TAX_AMOUNT DOUBLE Y This field stores calculated header level and line level tax amount.
TAX_IND DOUBLE Y This indicator shows whether the additional amount is considered as a tax.
TAX_TYPE_CD DOUBLE N Tax Type code from code set 14066
TAX_VALUE DOUBLE N Tax Value Amount
TAX_VALUE_FLAG DOUBLE N This flag indicates whether tax value is a percentage or fixed amount. 1 = Percentage; 2 = Fixed Amount; 0 = not assigned
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 - ADDITIONAL_AMOUNT


Child Column in ADDITIONAL_AMOUNT(FK) Parent Table Name Parent Column Name
Parents: MM_PROJECT_NBR_TRACKING_ID MM_PROJECT_NBR_TRACKING MM_PROJECT_NBR_TRACKING_ID


ADDITIONAL_AMOUNT_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: ADDITIONAL AMOUNT DEF
Definition: Additional amounts associated with an item or location or item/location.
Table Type: REFERENCE





Column Detail - ADDITIONAL_AMOUNT_DEF


Column Name Type Null? Definition
ADDITIONAL_AMOUNT_CD DOUBLE N Additional amount Code
ADDITIONAL_AMOUNT_DEF_ID DOUBLE N Primary key
COST_CENTER_CD DOUBLE N Cost center
INCLUDE_EXCLUDE_IND DOUBLE N Apply / don't apply? Yes/No
ITEM_ID DOUBLE N Foreign key to an item.
LOCATION_CD DOUBLE N Location code value
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.
ORGANIZATION_ID DOUBLE N Foreign Key to the Organization table.
SUB_ACCOUNT_CD DOUBLE N Sub account code
TAX_OVERRIDE_IND DOUBLE N This indicator will determine whether the tax set at an item level will override the tax set at organization level.
TAX_TYPE_CD DOUBLE N Tax Type Code from code set 14066
TAX_VALUE DOUBLE N Tax Value amount
TAX_VALUE_FLAG DOUBLE N This flag indicates whether tax value is a percentage or fixed amount.
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 - ADDITIONAL_AMOUNT_DEF


Child Column in ADDITIONAL_AMOUNT_DEF(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


INVOICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: INVOICE
Definition: Main invoice header table.
Table Type: ACTIVITY





Column Detail - INVOICE


Column Name Type Null? Definition
APPROVED_DT_TM DATETIME Y When approved/unapproved
APPROVED_IND DOUBLE N Indicates, invoice approved or not
APPROVED_PRSNL_ID DOUBLE N Person_id of the person from the personnel table (prsnl) that caused the approved/unapproved the invoice.
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.
INVOICE_AMOUNT DOUBLE Y The total money amount of the invoice entered by the user.
INVOICE_DT_TM DATETIME Y The date and time on the invoice from the vendor.
INVOICE_ID DOUBLE N The system assigned unique identifier for the invoice being vouchered.
INVOICE_NBR VARCHAR(40) Y The Invoice Number provided by the vendor on the invoice document. Frequently this number is a statement date when an invoice number is not provided.
INVOICE_NBR_KEY VARCHAR(40) Y Invoice Number KEY
INVOICE_NBR_KEY_A_NLS VARCHAR(160) Y INVOICE_NBR_KEY_A_NLS column
INVOICE_NBR_KEY_NLS VARCHAR(82) Y Invoice Number KEY NLS
INV_PROFILE_ID DOUBLE Y The invoice profile that the invoice was created using.
LAST_INTERFACED_DT_TM DATETIME Y The last date that the invoice was transmitted to a foreign system.
LAST_TRANSMIT_DT_TM DATETIME Y last transmit date and time
MATCHED_IND DOUBLE Y Indicates whether or not the invoice has been 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.
PAID_STATUS_IND DOUBLE Y The Paid Status Indicator may provide indication that the invoice has actually been paid when a two way accounts payable interface is present.
PAYMENT_AMOUNT DOUBLE Y The amount to be paid.
PAYMENT_DT_TM DATETIME Y The Payment Date Time may provide the date and time that the invoice was actually paid when a two way accounts payable interface is present.
PAYMENT_NBR VARCHAR(40) Y The Payment Number identifies the specific funds transfer or check number that the invoice was paid on when a two way accounts payable interface is present.
PURCHASE_ORDER_ID DOUBLE N Foreign key to the purchase_order table.
REMIT_ADDRESS_ID DOUBLE Y The address of the remittance site.
SEQUENCE DOUBLE Y The system assigned sequence number for this invoice.
STATUS_CD DOUBLE N The Status code identifies whether the invoice is open, pending or closed. Pending indicates matched but that the voucher is not assigned as auto or hand.
SYSTEM_GENERATED_IND DOUBLE Y system generated indicator
TERMS_CD DOUBLE N The payment terms for this invoice.
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_CD DOUBLE N The Vendor Code identifies the vendor from whom the invoice is issued.
VENDOR_PO_REF VARCHAR(40) Y A free-text field from the PO.
VENDOR_SITE_ID DOUBLE N Foreign key to vendor_site table.
VOUCHER_DT_TM DATETIME Y The date of the voucher.
VOUCHER_EFFECTIVE_DT_TM DATETIME Y The effective date of the voucher.
VOUCHER_STATUS_CD DOUBLE N The Voucher Status Code identifies the current status of the Vouchered invoice.
VOUCHER_USER_ID DOUBLE N The Voucher User Id indicates the User id of the person who initially added the record.



Relationship Detail - INVOICE


Child Column in INVOICE(FK) Parent Table Name Parent Column Name
Parents: REMIT_ADDRESS_ID ADDRESS ADDRESS_ID
INV_PROFILE_ID MM_PROFILE PROFILE_ID
APPROVED_PRSNL_ID PRSNL PERSON_ID
PURCHASE_ORDER_ID PURCHASE_ORDER PURCHASE_ORDER_ID
VENDOR_SITE_ID VENDOR_SITE VENDOR_SITE_ID




Parent Column in INVOICE (PK) Child Table Name Child Column Name
Children: INVOICE_ID INVOICE_LINE_ITEM INVOICE_ID
INVOICE_PO_RECEIPT_R INVOICE_ID
MM_AP_LOG_HEADER_HMW INVOICE_ID


INVOICE_LINE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Invoice Line Item
Definition: Holds all line items for an invoice.
Table Type: ACTIVITY





Column Detail - INVOICE_LINE_ITEM


Column Name Type Null? Definition
BUYER_ID DOUBLE N Buyer ID of the Buyer
CHECKED_IND DOUBLE Y Indicates whether this line is included on this invoice.
COST_CENTER_CD DOUBLE N This cost center for which this line will be charged.
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.
INVOICE_ID DOUBLE N Foreign key to the invoice table.
INVOICE_LINE_ITEM_ID DOUBLE N The identifier assigned to line item on an invoice
LINE_ITEM_ID DOUBLE N Foreign key to line_item table.
MATCHED_IND DOUBLE Y This field determines if the line has been matched to an invoice.
PO_LINE_NBR DOUBLE Y The line number for this line from the purchase order.
STATUS_CD DOUBLE N The status of the line.
SUB_ACCOUNT_CD DOUBLE N The sub-account for which to charge this item.
TRANSMIT_CD DOUBLE Y Indicates the status of transmission to an AP system.
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 - INVOICE_LINE_ITEM


Child Column in INVOICE_LINE_ITEM(FK) Parent Table Name Parent Column Name
Parents: INVOICE_ID INVOICE INVOICE_ID
LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID




Parent Column in INVOICE_LINE_ITEM (PK) Child Table Name Child Column Name
Children: INVOICE_LINE_ITEM_ID MM_AP_LOG_LINE_HMW INVOICE_LINE_ITEM_ID


INVOICE_PO_RECEIPT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Invoice - PO Receipt Relationship
Definition: This table describes which receipts were invoiced for a specific invoice.
Table Type: ACTIVITY





Column Detail - INVOICE_PO_RECEIPT_R


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 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.
INVOICE_ID DOUBLE N Foreign key to invoice table.
PO_RECEIPT_ID DOUBLE N Foreign key to po_receipt 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 - INVOICE_PO_RECEIPT_R


Child Column in INVOICE_PO_RECEIPT_R(FK) Parent Table Name Parent Column Name
Parents: INVOICE_ID INVOICE INVOICE_ID
PO_RECEIPT_ID PO_RECEIPT PO_RECEIPT_ID