MM_AP_LOG_HEADER_HMW



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Log Header
Definition: AP Log Header
Table Type: ACTIVITY





Column Detail - MM_AP_LOG_HEADER_HMW


Column Name Type Null? Definition
COMPANY_CODE VARCHAR(20) Y Company Code or Number
CREATE_ID DOUBLE N ID of user who created this row
CREATE_NAME VARCHAR(100) Y Create Name
FREIGHT_AMT DOUBLE Y Freight Amount
GROSS_AMT DOUBLE Y Gross Amount
HEADER_ID DOUBLE N Primary Key
INVOICE_DT_TM DATETIME Y Invoice Date
INVOICE_ID DOUBLE N Invoice ID
INVOICE_NBR VARCHAR(40) Y Invoice Number
LOG_ID DOUBLE N Foreign Key
ORGANIZATION_ID DOUBLE N Organization ID
PAYMENT_TERMS VARCHAR(60) Y Payment Terms
PAYMENT_TERMS_CD DOUBLE N Payment Terms
RAW_VOUCHER_HEADER VARCHAR(200) Y The actual text written out to the file.
SALES_TAX_AMT DOUBLE Y Sales Tax Amount
TOTAL_VOUCHER_LINES DOUBLE Y Total Voucher Lines
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 VARCHAR(40) Y Vendor
VENDOR_ALIAS VARCHAR(20) Y Vendor Alias
VENDOR_CD DOUBLE N Vendor associated with this account



Relationship Detail - MM_AP_LOG_HEADER_HMW


Child Column in MM_AP_LOG_HEADER_HMW(FK) Parent Table Name Parent Column Name
Parents: INVOICE_ID INVOICE INVOICE_ID
LOG_ID MM_AP_LOG_HMW LOG_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_AP_LOG_HMW



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM AP LOG HMW
Definition: AP Log table for HLTH_MO only.
Table Type: ACTIVITY





Column Detail - MM_AP_LOG_HMW


Column Name Type Null? Definition
BATCH_NBR DOUBLE Y Batch Number
BATCH_SELECTION VARCHAR(100) Y Batch Selection
COMMENTS VARCHAR(100) Y Comments
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y 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
FILENAME VARCHAR(100) Y File Name
LOG_ID DOUBLE N Primary Key
OUTPUT_DIST VARCHAR(100) Y Output Distribution (operations parameter)
TOTAL_FREIGHT_AMT DOUBLE Y Total Freight Amount
TOTAL_GROSS_AMT DOUBLE Y Total Gross Amount
TOTAL_INVOICES DOUBLE Y Total Invoices
TOTAL_LINES DOUBLE Y Total Invoice Lines
TOTAL_LINE_AMT DOUBLE Y Total line amount
TOTAL_SALES_TAX_AMT DOUBLE Y Total Sales Tax 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 - MM_AP_LOG_HMW




Parent Column in MM_AP_LOG_HMW (PK) Child Table Name Child Column Name
Children: LOG_ID MM_AP_LOG_HEADER_HMW LOG_ID


MM_AP_LOG_LINE_HMW



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Log Line
Definition: AP Log Line
Table Type: ACTIVITY





Column Detail - MM_AP_LOG_LINE_HMW


Column Name Type Null? Definition
COMPANY_CODE VARCHAR(20) Y Company Code
COST_CENTER VARCHAR(60) Y Cost Center number
COST_CENTER_CD DOUBLE N Cost Center codevalue
EXTENDED_AMT DOUBLE Y Extended Amount
HEADER_ID DOUBLE N Foreign Key
INVOICE_LINE_ITEM_ID DOUBLE N Invoice line item
INVOICE_LINE_NBR DOUBLE Y Invoice line number
ITEM_DESC VARCHAR(100) Y Item description
ITEM_ID DOUBLE N The unique id for the item master.
LINE_ID DOUBLE N Primary Key
ORGANIZATION_ID DOUBLE N Organization ID
PO_NBR VARCHAR(40) Y PO Number
PURCHASE_ORDER_ID DOUBLE N Purchase order ID
RAW_DIST_LINE VARCHAR(200) Y Raw line written to file.
RAW_VOUCHER_LINE VARCHAR(200) Y Raw voucher line
SUB_ACCOUNT VARCHAR(60) Y Sub Account
SUB_ACCOUNT_CD DOUBLE N Sub Account codevalue
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_AP_LOG_LINE_HMW


Child Column in MM_AP_LOG_LINE_HMW(FK) Parent Table Name Parent Column Name
Parents: INVOICE_LINE_ITEM_ID INVOICE_LINE_ITEM INVOICE_LINE_ITEM_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PURCHASE_ORDER_ID PURCHASE_ORDER PURCHASE_ORDER_ID


MM_GL_LOG_DETAIL_HMW



Column Section Top of Page


Table-level Detail

Description: GL Log detail table
Definition: Gl Log Detail Table
Table Type: ACTIVITY





Column Detail - MM_GL_LOG_DETAIL_HMW


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date and time the row was last inserted or updated.
CREDIT_ACCOUNT VARCHAR(40) Y Credit Account
CREDIT_ACCOUNT_CLASS VARCHAR(10) Y Credit Account Class
CREDIT_AMOUNT DOUBLE Y Credit Amount
CREDIT_COMPANY VARCHAR(20) Y Credit Company
CREDIT_COST_CENTER VARCHAR(20) Y Credit Cost Center
CREDIT_COST_CENTER_CD DOUBLE N Credit Cost Center Code
CREDIT_INDICATOR VARCHAR(1) Y Credit Indicator
CREDIT_ORG_ID DOUBLE N Credit Organization ID
CREDIT_SUBACCOUNT VARCHAR(20) Y Credit SubAccount Code
CREDIT_SUBACCOUNT_CD DOUBLE N Credit SubAccount Code
DEBIT_ACCOUNT VARCHAR(40) Y Debit Account
DEBIT_ACCOUNT_CLASS VARCHAR(10) Y Debit Account Class
DEBIT_AMOUNT DOUBLE Y Debit Amount
DEBIT_COMPANY VARCHAR(20) Y Debit Company
DEBIT_COST_CENTER VARCHAR(20) Y Debit Cost Center
DEBIT_COST_CENTER_CD DOUBLE N Debit Cost Center Code
DEBIT_INDICATOR VARCHAR(1) Y Debit Indicator
DEBIT_ORG_ID DOUBLE N Debit Organization ID
DEBIT_SUBACCOUNT VARCHAR(20) Y Debit Sub Account
DEBIT_SUBACCOUNT_CD DOUBLE N Debit Sub Account Code
LOG_DETAIL_ID DOUBLE N Primary Key
LOG_ID DOUBLE N Foreight Key to mm_gl_log_hmw table
RAW_GL_LINE VARCHAR(200) Y A duplicate of the line that was written to the flat file.
REVERSAL_IND DOUBLE Y Indicator used to determine if the entry is a month end posting or a reversal for the previous month.
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.


MM_GL_LOG_HMW



Column Section Top of Page


Table-level Detail

Description: MM GL LOG HMW
Definition: GL Log header table for HMW
Table Type: ACTIVITY





Column Detail - MM_GL_LOG_HMW


Column Name Type Null? Definition
BATCH_NBR DOUBLE Y Batch Number
BATCH_SELECTION VARCHAR(500) Y Batch Selection
COMMENTS VARCHAR(100) Y Comments
FILENAME VARCHAR(100) Y Filename
LOG_ID DOUBLE N Primary Key
OUTPUT_DIST VARCHAR(100) Y Output Destination
REV_FILENAME VARCHAR(100) Y Reversal Filename
TOTAL_AMT DOUBLE Y Total Amount
TOTAL_CREDIT_AMT DOUBLE Y Total Credit Amount
TOTAL_CREDIT_LINES DOUBLE Y Number of credit lines
TOTAL_DEBIT_AMT DOUBLE Y Total Debit Amount
TOTAL_DEBIT_LINES DOUBLE Y Total Debit Lines
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.