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. |