| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP09: General Accounting |
1 | F09523 | Cash Forecast Reporting Structures | 3 | FS | PNTCSH | Parent Cash Type | String | UDC | 10 | 0 |
2 | F09UI017 | Cash Forecast Detail | 14 | FW | PNTCSH | Parent Cash Type | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 09 / CT (Cash Types) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | 1_BAL | Opening Balances | 10 | Y |
2 | 1_IN | Incoming Cash | 10 | Y |
3 | 1_NETOP | Net Operating Forecast | 10 | Y |
4 | 1_OUT | Outgoing Cash | 10 | Y |
5 | 1_TOTCF | Cash Forecast | 10 | Y |
6 | BANK | Bank Accounts | | N |
7 | CD | Certificates of Deposit | | N |
8 | INV | Open Invoices | 10 | N |
9 | INVCK | Open Invoices by Check | | N |
10 | INVCK07 | Inv fm Ck Past Due 1-7 days | | N |
11 | INVCK14 | Inv fm Ck Past Due 8-14 days | | N |
12 | INVCKPD | Inv fm Checks Past Due | 10 | N |
13 | INVEFT | Open Invoices by EFT | | N |
14 | INVEFT07 | Inv EFT Past Due 1-7 days | | N |
15 | INVEFT14 | Inv EFT Past Due 8-14 days | | N |
16 | INVEFTPD | Inv EFT Past Due | 10 | N |
17 | INVPD | Invoices Past Due | 10 | N |
18 | SAV | Savings Accounts | | N |
19 | VOU | Open Vouchers | 10 | N |
20 | VOUCK | Open Vouchers by Check | | N |
21 | VOUCK07 | Vouch by Ck Past Due1-7 days | | N |
22 | VOUCK14 | Vouch by Ck Past Due 8-14 days | | N |
23 | VOUCKPD | Vouch by Ck Past Due | 10 | N |
24 | VOUEFT | Open Vouchers by EFT | | N |
25 | VOUEFT07 | Vouch EFT Past Due1-7 days | | N |
26 | VOUEFT14 | Vouch EFT Past Due 8-14 days | | N |
27 | VOUEFTPD | Vouch EFT Past Due | 10 | N |
28 | VOUPD | Vouchers Past Due | 10 | N |