| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CICWTMPT | Closing Worksheet Template | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | CICLSRT | Closing Worksheet Line Item | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | CICLDESC | Closing Line Item Description | String | Generic Edit | 50 | 0 | Allow NULL? |
| 4 | CIMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | CICLMCD | Closing Business Unit Value | String | UDC (44H5 BU) | 3 | 0 | Allow NULL? |
| 6 | CIOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 7 | CISUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | CILT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 9 | CIBDLT | Budget Ledger Type | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 10 | CISBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | CISBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 12 | CICLSCD | Closing Subledger Value | String | UDC (44H5 SL) | 3 | 0 | Allow NULL? |
| 13 | CICLDBCR | Closing Debit Credit Code | String | UDC (44H5 DC) | 2 | 0 | Allow NULL? |
| 14 | CICLTAMT | ClosingTemplateScheduledAmount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | CIAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | CIU | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | CICRTU | Created by user | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | CICRTJ | Date - Created | Date | Generic Edit | 6 | 0 | |
| 19 | CICRTT | Time - Created | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | CIWRKSTNID | Original Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | CIHBOPID | Original Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | CIUPMB | Updated By - User | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | CIUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 24 | CIUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 25 | CIJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | CIPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |