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 |