RA_ReceiptsHistoryLotSerial RA Receipts History Lot Serial Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_GenerateTransactions_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryLotSerial.M4T"
KPRIMARY: RMANo+ReceiptSeqNo+ReceiptDetailSeqNo+LotSerialNo
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{RA_05$(1,7)}
2 ReceiptSeqNo. . . . . . . . . 6 SNN Receipt Sequence Number . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RA_05$(8,5)}
3 ReceiptDetailSeqNo. . . . . . 6 SNN Receipt Detail Sequence Number.
Mask:000000 FmtType:ZEROFILL
Notes: {RA_05$(13,10)}
4 LotSerialNo . . . . . . . . . 15 SYN Lot Serial Number . . . . . . .LOTSERIALNO
FmtType:CHARNUM Notes:
{RA_05$(23,15)}
5 TierType. . . . . . . . . . . 1 SYN Tier Type . . . . . . . . . . .
Valid:3,4 Notes: 3=Lot,
4=Serial
6 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY
Mask:##,###,###.000000-
7 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
8 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
9 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL