FGLOT -- Finished good item master
FGLASM -- Finished good balance per color size
Each lot refer to a finish good balance of a product (style). Noted that the lot keep two balances, Qty the inventory balance and CtnQty the quantity of the products packed into boxes. It is possible that the CtnQty is less than the Qty. In this case, the different are the number of items which are not packed.
TABLE FGLOT Finished good item master
KEY
Primary=LotID
StyleKey=Style, OrderNo
FIELDS
LotID I
AUTO_INC:
Style A15 Style Number
MATCH: FGMITEM:Style,OrderNo
OrderNo A14 Order Number
MATCH: FGMITEM:Style,OrderNo
Unit A3 Quantity Unit
EXIST: SYMUNIT:Code
Description A60 Short Description
FullDesc M60 Full Description
ExtDesc1 A256 <Style Custom Desc1>
ExtDesc2 A256 <Style Custom Desc2>
ExtDesc3 A256 <Style Custom Desc3>
ExtDesc4 A256 <Style Custom Desc4>
ExtDesc5 A256 <Style Custom Desc5>
ExtDesc6 A256 <Style Custom Desc6>
ExtDesc7 A256 <Style Custom Desc7>
ExtDesc8 A256 <Style Custom Desc8>
ExtDesc9 A256 <Style Custom Desc9>
ExtDesc10 A256 <Style Custom Desc10>
GmtType A4 Garment Type
EXIST: SYGTYPE:Code
Qty N Balance qty
Amt N
LastMoved D10
PckCnt N Packed carton count
PckQty N Packed quantity
.
TABLE FGLASM Finish good warehouse stock assortment
MASTER
FGLOT(LotID)
KEY
Primary=LotID, WhCode, Color, Sizx, Dim3
FIELDS
LotID I
WhCode A5 Warehouse
EXIST: SYNMLOC:Code
Color A32 Color
EXIST: SYGCOLOR:Color
Sizx A16 Size
EXIST: SYGSIZE:Sizx
Dim3 A8 3rd Dim
EXIST: SYGDIM3:Dim3
Qty N Quantity
Amt N Value
.
FGLTRX -- Finished good movement trx
FGLXASM -- Finished good movement trx assortment
Note that movement transcation are created by Movement Note. Please refer to the Finish Good Movement Voucher API
TABLE FGLTRX Finish good movement trx header
KEY
Primary=TrxSysID
ItemKey=LotID, TrxSysID
FIELDS
TrxSysID I
AUTO_INC:
TrxDate D10 Trx Date
TrxType A4 Trx Type
ENUM: PRD+, PRD-, ADJ+, ADJ-, SHP-, SHP+, TRF-, TRF+, PAK+, PAK-
LotID I
MATCH: FGLOT:LotID
WhCode A5 Warehouse
EXIST: SYNMLOC:Code
TrxQty N Move Quantity
TrxAmt N Value
SysSource A3 Source document type
ENUM: MVN - FG Move Note
SysSrcRef A20 Source document reference
.
TABLE FGLXASM Finish good movement trx assortment
MASTER
FGLTRX(TrxSysID)
KEY
Primary=TrxSysID, Color, Sizx, Dim3
FIELDS
TrxSysID I
Color A32 Color
EXIST: SYGCOLOR:Color
Sizx A16 Size
EXIST: SYGSIZE:Sizx
Dim3 A8 3rd Dim
EXIST: SYGDIM3:Dim3
TrxQty N Move Quantity
TrxAmt N Value
.
TABLE FGLXCST Finish good movement trx costs
MASTER
FGLTRX(TrxSysID)
KEY
Primary=TrxSysID,itemNo
ItemKey=LotID, TrxSysID
FIELDS
TrxSysID I
ItemNo I
RefTrxID I Reference TrxID
HINT: Normally blank but has value if this Trx is build on reference
to another Trx.
LotID I
MATCH: FGLOT:LotID
Color A32 Color
EXIST: SYGCOLOR:Color
Sizx A16 Size
EXIST: SYGSIZE:Sizx
Dim3 A8 3rd Dim
EXIST: SYGDIM3:Dim3
CostClass A1 Cost Class
CHOICE: F - Fabric
CHOICE: A - Accessories
CHOICE: L - Labor
CostType A8 Cost Type
CHOICE: F - MatrClass
CHOICE: A - MatrClass
CHOICE: L - Process
DocRef A26 Doc Ref.
HINT: Material code for CostType is F or A
Qty N Quantity
QtyUnit A3 Qty Unit
EXIST: SYMUnit:Code
Cur A3 Currency
EXIST: SYMCURR:Code
Fx $12,6 Fx
Amt N Amount
.
FGCTN -- Finish good cartons
FGCDTL -- Carton carton contents
FGCBIN -- Carton bin reference
FGCTRX -- Carton movement transaction
Recording cartons of finised good in warehouse, each record represent a carton identified by a carton no. It is possible that there are more then one cartons with the same carton no, if every details of the cartons are the same.
Carton master is created by any kind of in fg in/out voucher. For in, it create a record, for out, it consume a record.
Stock balance Qty shall included Qty packed in box plus free qty. Qty packed in box should be moved in box. When moving finised good by item, one has to check against unpacked qty.
The unpacked qty = Stock Qty - Stock Qty in Carton, which is fg_item_asm.qty - fg_ctn_dtls.qty for a style, color, size.
TABLE FGCTN Carton master and properties
ANNOTATION
A unique reference of a carton of products.
KEY
Primary=CtnRef
FIELDS
CtnRef A32 Carton reference
GWght N Gross Weight
NWght N Net Weight
NNWght N Net Net Weight
Lngth N Carton Length
Width N Carton Width
Height N Carton Height
ShipMark M10 Shipping Mark
CtnCnt I Number of cartons
CALC: Sum(CtnCnt) in fg_ctn_bin
CtnTypeCode A1 Carton Type Code
Prepack A20 Prepack
.
TABLE FGCDTL Carton contents
ANNOTATION
Detail article include in each prepack per carton.
MASTER
FGCTN(CtnRef)
KEY
Primary=CtnRef,Style,Color,Sizx,Dim3
StyleKey=Style,OrderNo
FIELDS
CtnRef A32 Carton reference
Style A16 Style
MATCH: SAOSTYLE:OrderNo,Style
OrderNo A14 Order Number
MATCH: SAOSTYLE:OrderNo,Style
Color A32 Color
EXIST: SYGCOLOR:Color
Sizx A16 Size
EXIST: SYGSIZE:Sizx
Dim3 A8 3rd Dim
EXIST: SYGDIM3:Dim3
Qty N Quantity
.
TABLE FGCBIN Carton bin reference
MASTER
FGCTN(CtnRef)
KEY
Primary=CtnRef, WhCode, BinRef
WHKey=WhCode
FIELDS
CtnRef A32 Carton reference
WhCode A5 Storage location
EXIST: SYNMLOC:Code
BinRef A32 Storage location reference
CtnCnt I Number of cartons
.
TABLE FGCTRX Carton movement transaction
KEY
Primary=SysID
CtnKey=CtnRef, SysID
DocKey=DocRefNo, CtnRef
FIELDS
SysID I
AUTO_INC:
TrxDate D10 Trx Date
TrxType A4 Trx Type
CtnRef A32 Carton reference
WhCode A5 Warehouse
EXIST: SYNMLOC:Code
DocRefNo A20 Movement document reference number
CtnCnt I Number of cartons
.