| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CCCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | CCNAME | Name | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | CCALTC | Alternate Company Name | String | Generic Edit | 40 | 0 | Allow NULL? |
| 4 | CCDFYJ | Date - Fiscal Year Begins | Date | Generic Edit | 6 | 0 | |
| 5 | CCPNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | CCDOT1 | Allow Multi-Currency Intercompany Trans. | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | CCCRYR | Currency Conversion Y/N/Z | Character | UDC (H00 CR) | 1 | 0 | Allow NULL? |
| 8 | CCCRYC | Search Type Security - Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | CCDOT2 | Computation ID | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | CCMCUA | Default CC - Use for Asset Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | CCMCUD | Default CC - Use for Depreciation Exp. | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | CCMCUC | Default CC - Use for Accumulated Depre | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | CCMCUB | Default CC - Use for Revenue-Billing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | CCDPRC | Voucher Redistribution Suspense | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | CCBKTX | Detailed Currency Restatement | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | CCTXBM | Tax Year - Beginning Month | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 17 | CCTXBO | Tax Year - Beginning Month - Old OBSOLET | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 18 | CCNWXJ | Date - New Tax Year End | Date | Generic Edit | 6 | 0 | |
| 19 | CCGLIE | Display 10 Class Codes (Y/N) | Character | UDC (H12 GL) | 1 | 0 | Allow NULL? |
| 20 | CCABIN | Post Account Balances by Currency | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | CCCALD | Number of Periods - Normal | String | UDC (H00 CA) | 2 | 0 | Allow NULL? |
| 22 | CCDTPN | Fiscal Date Pattern | Character | UDC (H00 DP) | 1 | 0 | Allow NULL? |
| 23 | CCPNF | Period Number - Financial Reporting | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 24 | CCDFF | Financial Reporting Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 25 | CCCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 26 | CCSMI | Symbol Used to define Item Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | CCSMU | Symbol Used to define Unit Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | CCSMS | Symbol Used to define Serial Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | CCDNLT | Delinquency Notice (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | CCSTMT | Print Statement Y/N | Character | UDC (H03 ST) | 1 | 0 | Allow NULL? |
| 31 | CCATCS | Auto Receipt (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | CCALGM | Auto Receipt Algorithm Method | String | UDC (01 AA) | 2 | 0 | Allow NULL? |
| 33 | CCAGEM | Aging Method (1 2 3) | Character | UDC (H00 AH) | 1 | 0 | Allow NULL? |
| 34 | CCCRDY | Aging Days - A/R Current | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 35 | CCAGR1 | Aging Days - A/R 1 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | CCAGR2 | Aging Days - A/R 2 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 37 | CCAGR3 | Aging Days - A/R 3 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 38 | CCAGR4 | Aging Days - A/R 4 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 39 | CCAGR5 | Aging Days - A/R 5 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 40 | CCAGR6 | Aging Days - A/R 6 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | CCAGR7 | Aging Days - A/R 7 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | CCFRY | 52 Period Financial Reporting Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 43 | CCFRP | 52 Period Number - Financial Reporting | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 44 | CCNNP | 52 Period Number of Periods - Normal | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 45 | CCFP | Percentage Factor | Numeric | Generic Edit | 9 | 6 | Allow NULL? |
| 46 | CCAGE | Aging - Date Based On (I/D/G) | Character | UDC (H00 AG) | 1 | 0 | Allow NULL? |
| 47 | CCDAG | Date - Age as of | Date | Generic Edit | 6 | 0 | |
| 48 | CCARPN | Period Number - Accounts Receivable | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 49 | CCAPPN | Period Number - Accounts Payable | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 50 | CCARFJ | Date - A/R Fiscal Year Begins | Date | Generic Edit | 6 | 0 | |
| 51 | CCAPFJ | Date - A/P Fiscal Year Begins | Date | Generic Edit | 6 | 0 | |
| 52 | CCAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 53 | CCSGBK | Signature Block | String | Generic Edit | 40 | 0 | Allow NULL? |
| 54 | CCPTCO | Print Company Name | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 55 | CCX1 | For Future Use - Flag 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 56 | CCX2 | For Future Use - Flag 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 57 | CCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 58 | CCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 59 | CCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 60 | CCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | CCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 62 | CCTSID | Target System Identifier | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 63 | CCTSCO | Target Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 64 | CCTHCO | Source Alias System . . . . . . . . . | String | Generic Edit | 3 | 0 | Allow NULL? |
| 65 | CCAN8C | Target Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |