Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CASH_SUMMARY_SHEET_LAYOUT_ID | int | 4 | null |
|
|
The cash summary sheet layout ID |
|||||
| CASH_SUMMARY_SHEET_LAYOUT_NAME | varchar | 40 | √ | null |
|
|
The cash summary sheet layout name |
||||
| REQUIRE_DEPOSIT_SLIP_NUMBER | varchar | 5 | √ | null |
|
|
Whether deposit slip numbers are required for this cash summary sheet layout (Yes/No) |
||||
| RECORD_OVER_SHORT_JOURNAL_ENTRY | varchar | 5 | √ | null |
|
|
Whether over and short journal entries may be recorded for this cash summary sheet layout (Yes/No) |
||||
| OVER_CREDIT_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The GL account ID that credits for till overages should post to |
||||
| OVER_CREDIT_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The GL account name that credits for till overages should post to |
||||
| OVER_CREDIT_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The GL account number that credits for till overages should post to |
||||
| OVER_DEBIT_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The GL account ID that debits for till overages should post to |
||||
| OVER_DEBIT_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The GL account name that debits for till overages should post to |
||||
| OVER_DEBIT_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The GL account number that debits for till overages should post to |
||||
| SHORT_CREDIT_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The GL account ID that credits for till shortages should post to |
||||
| SHORT_CREDIT_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The GL account name that credits for till shortages should post to |
||||
| SHORT_CREDIT_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The GL account number that credits for till shortages should post to |
||||
| SHORT_DEBIT_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The GL account ID that debits for till shortages should post to |
||||
| SHORT_DEBIT_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The GL account name that debits for till shortages should post to |
||||
| SHORT_DEBIT_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The GL account number that debits for till shortages should post to |
||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether this cash summary sheet layout has been retired from further use (Yes/No) |
||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |