Download AS/400 - Acclaim Software

System Description
F I L E
L A Y O U T S
Item Master File
This file contains one record for every item entered.
File Name: CSSITEM
Record Format:
ITEMREC
Key Field(s):
ITCOMP, ITITEM
FMT
A
A
A
A
A
A
P
A
A
A
P
P
A
A
A
A
P
P
P
P
P
P
P
P
P
P
P
P
P
P
FIELD
NAME
ITDELT
ITCOMP
ITITEM
ITDESC
ITCLAS
ITLOC
ITWEHT
ITSTUM
ITPUUM
ITSEUM
ITPERP
ITPERS
ITAITM
ITVEND
ITAVEN
ITVITM
ITLEAD
ITOHND
ITRSRV
ITOORD
ITBKOR
ITMIN
ITMAX
ITEOQ
ITLPCH
ITLREC
ITLSAL
ITLCNT
ITLCST
ITACST
NO
BYTES
1
3
15
25
5
10
5
3
3
3
4
4
15
8
8
15
2
5
5
5
5
5
5
5
4
4
4
4
5
5
FIELD
LENGTH
1
3
15
25
5
10
9,4
3
3
3
7,2
7,2
15
8
8
15
3,0
9,2
9,2
9,2
9,2
9,2
9,2
9,2
6,0
6,0
6,0
6,0
9,3
9,3
FIELD
DESCRIPTION
Delete code
Company code
Item number
Description
Class
Location
Weight
Stock unit of measure
Purchasing unit of measure
Selling unit of measure
Stock units per Purch. U/M
Stock units per Selling U/M
Alternate item number
Vendor number
Alternate vendor number
Vendor's item number
Lead time (days,weeks,etc.)
Quantity on hand
Quantity reserved
Quantity on order
Quantity back ordered
Minimum quantity on hand
Maximum quantity on hand
Economic order quantity
Date of last purchase
Date of last receipt
Date of last sale
Date of last physical count
Last unit cost
Average cost
Section 1 Page 91
Introduction