RA_ReceiptsHistoryInvoice RA Receipts History Invoice Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesJournal_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryInvoice.M4T"
KPRIMARY: RMANo+InvoiceNo+HeaderSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYY RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{RA_08$(1,7)}
2 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{RA_08$(8,7)}
3 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RA_08$(15,3)}
4 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
Notes: {RA_08$(18,6)}
5 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE
Notes: {RA_08$(24,6)}
6 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{RA_08$(30,7)}
7 InvoiceTotal. . . . . . . . . 13.2 NNN Invoice Total . . . . . . . . .
Mask:###,###,###.00- Notes:
{RA_08[0]}
8 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
9 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
10 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL