View: Shipment Headers

RotoID: IC0640
Table: ICSHEH
Protocol: Header, Key auto generate
DLL:ICSHEH

Compositions: 3

RotoID Tables Title DLL

IC0630 ICSHED Shipment Details ICSHED
IC0390 ICPCOD Price List Codes ICPCOD
IC0645 ICSHEHO Shipment Optional Fields ICSHEHO

Keys: 6

Title Fields

Sequence Number SEQUENCENO
Transaction Number TRANSNUM
Record Status STATUSTRANSNUM
Document Number DOCNUM
IC-Unique Document Number DOCUNIQ
Status by Document Number STATUSDOCNUM

Fields: 32

Field Index Type Title Attributes Presentation

SEQUENCENO 1 Long Sequence Number E A K R 
TRANSNUM 2 BCD*10.0 Transaction Number E A C 
DOCNUM 3 String*22 Shipment Number E A  Mask: %-22C
HDRDESC 4 String*60 Description E A 
TRANSDATE 5 Date Ship Date E A 
FISCYEAR 6 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 7 Integer Fiscal Period E A P  List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
REFERENCE 8 String*60 Reference E A 
TRANSTYPE 9 Integer Entry Type E A  List:2 entries
1 = Shipment
2 = Return
CUSTNO 10 String*12 Customer Number E A  Mask: %-12C
CUSTNAME 11 String*60 Customer Name E A C 
CONTACT 12 String*60 Contact E A 
CURRENCY 13 String*3 Source Currency E A  Mask: %-3N
PRICELIST 14 String*6 Price List E A  Mask: %-6N
EXCHRATE 15 BCD*8.7 Exchange Rate E A 
RATETYPE 16 String*2 Rate Type E A  Mask: %-2N
RATEDATE 17 Date Rate Date E A 
RATEOP 18 Integer Rate Operation E A C  List:2 entries
1 = Multiply
2 = Divide
RATEOVRRD 19 Boolean Rate Override E A  List:2 entries
0 = No
1 = Yes
SERIALUNIQ 20 Integer Serial Number Uniquifier E A C 
JOBCOST 21 Boolean Job Related E A C  List:2 entries
0 = No
1 = Yes
DOCUNIQ 22 BCD*10.0 IC-Unique Document Number E A 
STATUS 23 Integer Record Status E A  List:4 entries
1 = Entered
2 = Posted
3 = Costed
20 = Day End Completed
DELETED 24 Boolean Record Deleted E A  List:2 entries
0 = No
1 = Yes
NEXTDTLNUM 25 Integer Next Detail Line Number E A C 
PRINTED 26 Boolean Record Printed E A  List:2 entries
0 = No
1 = Yes
VALUES 27 Long Optional Fields E A C 
ENTEREDBY 28 String*8 Entered By E A C  Mask: %-8N
DATEBUS 29 Date Posting Date E A 
CUSTEXISTS 101 Boolean Customer Exists A C  List:2 entries
0 = No
1 = Yes
POSTSEQNUM 102 Long Post Sequence Number A C 
PROCESSCMD 103 Integer Process Command E A C  List:2 entries
0 = Nothing to Process
1 = Insert Optional Fields