Table QUAYCRA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| QUAYCRA | CRA | Appointment management | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CRA0 | FCY+CRANUM | No | |
| CRA1 | FCY+STO+SLO+DAT+TIM+CRANUM | No | |
| CRA2 | FCY+DAT+STO+SLO+CRANUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CGTXCL | Transport type | CGT | [CGT]CGT0=FCY;CGTXCL | Block | ||||
| CLT | Client | CLT | [CLT]CLT0=FCY;CLT | Block | ||||
| CLTXCL | Ship to | CLT | [CLT]CLT0=FCY;CLTXCL | Block | ||||
| CRACLB | Comment | ACB | ||||||
| CRANUM | Carrier appointment | CRA | [CRA]CRA0=FCY;CRANUM | Other | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRR | Carrier | CRR | [CRR]CRR0=FCY;CRR | Block | ||||
| CRRMOD | Transportation method | CRM | [CRM]CRM0=FCY;CRRMOD | Block | ||||
| CRRNAM | Carrier name | NAM | ||||||
| CRRREF | Carriage reference | A | 15 | |||||
| CUQ | Number PAC | L | 8 | |||||
| DAT | Date | D | ||||||
| DENFCY | Destination site | FCY | [FCY]FCY0=[CRA]DENFCY | Block | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DES | Description | A | 20 | |||||
| DVR | Supplier | DVR | [DVR]DVR0=FCY;DVR | Block | ||||
| EFFOCC1DAT | Effective start date | D | ||||||
| EFFOCC1TIM | Time | HM | ||||||
| EFFOCC2DAT | Effective end date | D | ||||||
| EFFOCC2TIM | Time | HM | ||||||
| EXPLOD | Estimated load | QTY | ||||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| GDR | Generic round | GDR | [GDR]GDR0=FCY;GDR | Block | ||||
| HEANBR | DO no | C | 4 | |||||
| HISPTR | Archive | L | 8 | |||||
| INSFLG | Inter-site | M | 4 | 1 | ||||
| LINNBR | No. of lines | C | 4 | |||||
| LMT | Linear meters | QTY | ||||||
| LOAPRE | Load | DCB | 9.2 | |||||
| LOP | Work center | LOP | [LOP]LOP0=FCY;LOP | Delete | ||||
| NBLIG | DO/RDV no | C | 4 | |||||
| PRECAM1DAT | Exp. arrival date | D | ||||||
| PRECAM1TIM | Time | HM | ||||||
| PRECAM2DAT | Exp. departure date | D | ||||||
| PRECAM2TIM | Time | HM | ||||||
| PREOCC1DAT | Expected start date | D | ||||||
| PREOCC1TIM | Time | HM | ||||||
| PREOCC2DAT | Expected end date | D | ||||||
| PREOCC2TIM | Time | HM | ||||||
| QYMSTA | Status | M | 15 | 386 | ||||
| RDVCRE | Appointment creation type | M | 15 | 472 | ||||
| RDVSTA | Appointment status | M | 15 | 448 | ||||
| RDVTYP | Appointment type | M | 15 | 471 | ||||
| REACAM1DAT | Actual arrival date | D | ||||||
| REACAM1TIM | Time | HM | ||||||
| REACAM2DAT | Act. departure date | D | ||||||
| REACAM2TIM | Time | HM | ||||||
| REAOCC1DAT | Actual start date | D | ||||||
| REAOCC1TIM | Time | HM | ||||||
| REAOCC2DAT | Actual occup end date | D | ||||||
| REAOCC2TIM | Time | HM | ||||||
| SLO | Dock | SLO | [SLO]SLO0=FCY;STO;SLO | Block | ||||
| STO | Store | STO | [STO]STO0=FCY;STO | Block | ||||
| TER | Expected duration | HM | ||||||
| TIM | Time | HM | ||||||
| TRSSTA | Truck tracking status | TRS | [TRS]TRS0=FCY;TRSSTA | Block | ||||
| TYP | Obsolete | M | 15 | 366 | ||||
| UOM | Unit | UOM | [TUN]TUN0=[CRA]UOM | Delete | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VOL | Volume | QTY | ||||||
| WEI | Weight | QTY |