Download AS/400 - Acclaim Software

Transcript
System Description
F I L E
L A Y O U T S
Transaction Register History Files
...Continued
This file contains one record for every adjustment transaction updated.
File Name: CSSTREGA
Record Format:
TREGAREC
FMT
A
A
A
P
P
A
A
N
A
A
FIELD
NAME
Logical File(s):CSSTREG
Key Field(s):RACOMP, RAITEM, RADATE(YMD)
NO
BYTES
RACOMP
RAITEM
RATYPE
RAOHAD
RAOOAD
RAREFN
RACMNT
RADATE
RASTUM
RAPUUM
3
15
1
5
5
8
15
6
3
3
FIELD
LENGTH
3
15
1
9,2
9,2
8
15
6,0
3
3
FIELD
DESCRIPTION
Company code
Item number
Transaction type (A)
On hand quantity adjusted
On order quantity adjusted
Reference number
Comments/Reason
Date adjusted
Stock unit of measure
Purchasing unit of measure
This file contains one record for every purchase transaction updated.
File Name: CSSTREGP
Record Format:
TREGPREC
FMT
A
A
A
P
P
A
A
N
N
FIELD
NAME
RPCOMP
RPITEM
RPTYPE
RPQTY
RPUCST
RPVEND
RPPONO
RPDATE
RPDLVR
Logical File(s):CSSTREG
Key Field(s):RPCOMP, RPITEM, RPDATE(YMD)
NO
BYTES
3
15
1
5
5
8
8
6
6
FIELD
LENGTH
3
15
1
9,2
9,3
8
8
6,0
6,0
FIELD
DESCRIPTION
Company code
Item number
Transaction type (P)
Quantity ordered
Unit cost
Vendor number
Purchase order number
Date ordered
Delivery date
Section 1 Page 102
Introduction