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 STATUS, TRANSNUM
Document Number DOCNUM
IC-Unique Document Number DOCUNIQ
Status by Document Number STATUS, DOCNUM

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

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).