01. OVERVIEW
Use table A1T to control the receipt of Sales Orders, generated from the Sales Management Portal.
02. EXAMPLE OF USE
Table
Prefix | A1T |
Description | Order/Price Quote Int. Ctrl. |
Branch Sharing | 2 - Exclusive |
Unit Sharing | 2 - Exclusive |
Company Sharing | 2 - Exclusive |
Fields
Order | Field | Description | Type | Size | Decimals | Required |
1 | A1T_FILIAL | System Branch | 1 - Character | 2 | 0 | No |
2 | A1T_NUM | External Number of Order | 1 - Character | 36 | 0 | Yes |
3 | A1T_STATUS | Processing Status - 0 - Received.
- 1 - Being Processed.
- 2 - Finished.
- 3 - Error.
| 1 - Character | 1 | 0 | Yes |
4 | A1T_DTREC | Date of Receipt | 4 - Date | 8 | 0 | Yes |
5 | A1T_HRREC | Time of Receipt | 1 - Character | 5 | 0 | Yes |
6 | A1T_TPOPER | Type of Operation - 3 - Addition
- 4 - Editing
- 5 - Deletion
| 1 - Character | 1 | 0 | No |
7 | A1T_DTPROC | Processing Date | 4 - Date | 8 | 0 | No |
8 | A1T_HRPROC | Processing Time | 1 - Character | 5 | 0 | No |
9 | A1T_JRECEB | JSON object received | 5 - Memo | 10 | 0 | Yes |
10 | A1T_ERROR | Error Message | 5 - Memo | 10 | 0 | No |
11 | A1T_ROTINA | Routine the Job must run | 1 - Character | 10 | 0 | Yes |
Indexes
Order | Key | Description |
1 | A1T_FILIAL+A1T_NUM | Branch + Number |
2 | A1T_FILIAL+A1T_STATUS+DTOS(A1T_DTREC)+A1T_HRREC | Branch + Status + Receipt Date + Receipt Time |