|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ABSID
|
ABS ID
|
|
x(8)
|
|
|
|
ABSShipFrom
|
Ship From
|
|
x(8)
|
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
AlgoType
|
Type
|
|
X(2)
|
|
|
|
AverageTime
|
Time
|
|
->>,>>9.99
|
10
|
|
|
BulkPick
|
Bulk Pick
|
Bulk!Pick
|
x(8)
|
|
|
|
CloseDate
|
Closed
|
|
99/99/99
|
|
|
|
CloseProgname
|
Closed
|
|
x(10)
|
|
|
|
CloseTime
|
Close Time
|
|
->,>>>,>>9
|
|
|
|
CloseUserID
|
Closed
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CompDate
|
Completed Date
|
|
99/99/99
|
|
|
|
CompTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateProgName
|
Created ProgName
|
|
x(10)
|
|
|
|
CreateTime
|
Created Time
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created UserID
|
|
x(8)
|
|
|
|
CurrUserID
|
Current
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExistSample
|
Exist Sample
|
|
yes/no
|
|
|
|
Fail
|
Fail
|
|
yes/no
|
|
|
|
FromAltUM
|
From UM
|
Fr!UM
|
x(2)
|
|
|
|
FromDigit
|
From Digit
|
From!Digit
|
x(8)
|
|
|
|
FromLoc
|
From Location
|
From!Location
|
x(8)
|
|
|
|
FromLot
|
From Lot/Serial
|
|
x(18)
|
|
|
|
FromPart
|
From Item Number
|
|
x(18)
|
|
|
|
FromRef
|
From Reference
|
From!Reference
|
x(8)
|
|
|
|
FromSite
|
From Site
|
From!Site
|
x(8)
|
|
|
|
FromSlocgp
|
From SLocGrp
|
From!SLocGrp
|
x(8)
|
|
|
|
FromWhse
|
From Whse
|
From!Whse
|
x(8)
|
|
|
|
FromWlocgp
|
From WLocGrp
|
From!WLocGrp
|
x(8)
|
|
|
|
HardAssign
|
Hard Assignment
|
Hard
|
yes/no
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
IntRouteSeq
|
Seq
|
|
>>9
|
|
|
|
InventNbr
|
Internal Inventory ID
|
Internal!Invent ID
|
99999999
|
|
|
|
IssDSet
|
Issue Data Set
|
|
x(12)
|
|
|
|
IssLine
|
Issue Line/ID
|
Issue!Line/ID
|
x(8)
|
|
|
|
IssNbr
|
Issue Order
|
|
x(18)
|
|
|
|
IssTrNbr
|
Issue
|
|
>>>>>>>>>9
|
|
|
|
KeepFromStatus
|
Keep From Status
|
Keep!From!Status
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
NumTasks
|
Num Tasks
|
|
->>,>>9.99
|
10
|
|
|
oid_TranD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrigFrLoc
|
Original From Location
|
Original!From Loc
|
x(8)
|
|
|
|
OrigFrLot
|
Original From Lot/Serial
|
Original!From Lot/Serial
|
x(18)
|
|
|
|
OrigFrPart
|
Original From Item Number
|
Original!From Item Number
|
x(18)
|
|
|
|
OrigFrRef
|
Original From Reference
|
Original!From Ref
|
x(8)
|
|
|
|
OrigToLoc
|
Original To Location
|
Original!To Loc
|
x(8)
|
|
|
|
OrigToLot
|
Original To Lot/Serial
|
Original!To Lot/Serial
|
x(18)
|
|
|
|
OrigToPart
|
Original To Item Number
|
Original!To Item Number
|
x(18)
|
|
|
|
OrigToRef
|
Original To Reference
|
Original!To Reference
|
x(8)
|
|
|
|
Project
|
Project
|
|
x(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
QtyAct
|
Actual
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
QtyExp
|
Expected
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Reason
|
Reason
|
|
x(8)
|
|
|
|
RecDSet
|
Receipt Data Set
|
|
x(12)
|
|
|
|
Receiver
|
Receiver
|
|
x(8)
|
|
|
|
RecLine
|
Receipt Line/ID
|
Receipt!Line/ID
|
x(8)
|
|
|
|
RecNbr
|
Receipt Order
|
|
x(18)
|
|
|
|
RecReqNbr
|
Requisition
|
|
x(8)
|
|
|
|
RecTrNbr
|
Receipt
|
|
>>>>>>>>>9
|
|
|
|
RelNbr
|
Release Group Nbr
|
Rel Grp
|
>>>>>>>9
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
SampleID
|
Sample ID
|
ID
|
>>>>>>>9
|
|
|
|
SessionID
|
Session ID
|
|
x(24)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SOJob
|
SO Job
|
|
x(8)
|
|
|
|
StageStatus
|
Stage Status
|
Stg
|
x(2)
|
|
|
|
StartDate
|
Started
|
|
99/99/99
|
|
|
|
StartProgname
|
Started
|
|
x(10)
|
|
|
|
StartTime
|
Start Time
|
|
->,>>>,>>9
|
|
|
|
StartUserID
|
Started
|
|
x(8)
|
|
|
|
SystemCode
|
System
|
|
x(2)
|
|
|
|
SystemProcCode
|
Procedure Code
|
Proc
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
ToAltUM
|
To UM
|
To!UM
|
x(2)
|
|
|
|
ToDigit
|
To Digit
|
|
x(8)
|
|
|
|
ToLoc
|
To Location
|
To Loc
|
x(8)
|
|
|
|
ToLot
|
To Lot/Serial
|
|
x(18)
|
|
|
|
ToPart
|
To Item Number
|
|
x(18)
|
|
|
|
ToRef
|
To Reference
|
To!Reference
|
x(8)
|
|
|
|
ToSite
|
To Site
|
|
x(8)
|
|
|
|
ToSlocGp
|
To SLocGrp
|
To!SLocGrp
|
x(8)
|
|
|
|
ToWhse
|
To Whse
|
|
x(8)
|
|
|
|
ToWlocgp
|
To WLocGrp
|
To!WLocGrp
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
TrPriInc
|
Increment
|
|
->,>>>,>>9
|
|
|
|
TrPriority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
TrStatus
|
Status
|
St
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
TwoPhase
|
Two Phase
|
2Ph
|
yes/no
|
|
|
|
UltLoc
|
Ultimate Location
|
Ultimate!Location
|
x(8)
|
|
|
|
UltSite
|
Ultimate Site
|
Ultimate!Site
|
x(8)
|
|
|
|
UltSlocgp
|
Ultimate SLocGrp
|
Ultimate!SLocGrp
|
x(8)
|
|
|
|
UltWhse
|
Ultimate Warehouse
|
Ultimate!Whse
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 1
|
|
99/99/99
|
|
|
|
WaveNbr
|
Wave Number
|
Wave Nbr
|
x(8)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
WLocGp
|
Work Loc Group
|
WLocGrp
|
x(8)
|
|
|
|
xPrevQtyAct
|
Previous Actual
|
Previous!Actual
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
FromLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromLoc
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
FromPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
FromSLocGp
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromSlocgp
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
InventNbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InventNbr
|
yes
|
no
|
|
|
IssOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
IssDSet
|
yes
|
no
|
|
|
|
|
IssNbr
|
yes
|
no
|
|
|
|
|
IssLine
|
yes
|
no
|
|
|
oid_TranD
|
yes
|
oid_TranD
|
yes
|
no
|
|
|
RecOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
RecDSet
|
yes
|
no
|
|
|
|
|
RecNbr
|
yes
|
no
|
|
|
|
|
RecLine
|
yes
|
no
|
|
|
RelGroup
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
RelNbr
|
yes
|
no
|
|
|
SampleID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SampleID
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
SessionID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SessionID
|
yes
|
no
|
|
|
SiteWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
StatusTo
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
Task
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SystemCode
|
yes
|
no
|
|
|
|
|
Task
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
ToLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToWhse
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
|
|
|
ToLot
|
yes
|
no
|
|
|
|
|
ToRef
|
yes
|
no
|
|
|
ToPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
∗
|
TrNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
TrStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
|
|
SystemCode
|
yes
|
no
|
|
|
|
|
SystemProcCode
|
yes
|
no
|
|
|
UltLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UltSite
|
yes
|
no
|
|
|
|
|
UltWhse
|
yes
|
no
|
|
|
|
|
UltSlocgp
|
yes
|
no
|
|
|
|
|
UltLoc
|
yes
|
no
|
|
|
UltSiteLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UltSite
|
yes
|
no
|
|
|
|
|
UltLoc
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Wave
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
WaveNbr
|
yes
|
no
|
|
|
WLocGp
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
WLocGp
|
yes
|
no
|