Ga naar inhoud

Table ReturOutDet

Purpose

Retour outgoing invoice, details.

Field definitions in table ReturOutDet

No. Used Name Type Reqd. Description
1 Y IDNO NUMERIC(0,18) Y Reference to RETUROUT record
2 Y PalNo VARCHAR(50) N Pallette number
3 Y ReturNo VARCHAR(50) N Retour number
4 Y TransactionType VARCHAR(50) N Transaction type
5 Y CREATIONDATE TIMESTAMP N Date record was created
6 Y CREATIONTIME VARCHAR(50) N Date record was created
7 Y PCNAME VARCHAR(50) N Creator of record
8 Y Picked VARCHAR(1) N Has been picked ?
9 Y PickedBy VARCHAR(50) N Person who picked it
10 Y PickedDate TIMESTAMP N Date when picked
11 Y ID NUMERIC(0,18) N Unique ID

Indexes