RA_GenerateTransactions RA Generate Transactions Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_GenerateTransactions.M4T"
KPRIMARY: DocumentType+RMANo+ARDivisionNo+CustomerNo+InvoiceNoHistory+SequenceNo+ItemCode+ReceiptsDetai
lLineKey
KWHSE: DocumentType+APDivisionNo+VendorNo+RMANo+ItemCode+WarehouseCode+ReceiptsDetailLineKey
KRMANO: RMANo
KCUSTVNDR: ARDivisionNo+CustomerNo+RMALineKey+ItemCode+RMANo+DocumentType+InvoiceNoHistory+SequenceNo+R
eceiptsDetailLineKey
KRMACUSTVNDR: DocumentType+RMANo+ARDivisionNo+CustomerNo+InvoiceNoHistory+SequenceNo+RMALineKey+ItemCod
e+ReceiptsDetailLineKey
KVENDOR: DocumentType+RMANo+APDivisionNo+VendorNo+InvoiceNoHistory+SequenceNo+ItemCode+ReceiptsDetailLi
neKey
Fld Column Name M/L TUR Description/Notes Class
1 DocumentType. . . . . . . . . 1 SYY Document Type . . . . . . . . .
Valid:C,O,P,R,X Notes:
C=Credit memo, O=sales Order,
P=Purchase order, R=Return
order, X=repair {RAH$(1,1)}
2 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{RAH$(2,7)}
3 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {RAH$(9,2)}
4 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{RAH$(11,7)}
5 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
6 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$
7 InvoiceNoHistory. . . . . . . 7 SYN Invoice Number in History . . .INVOICE
FmtType:MASTERNUM Notes:
{RAH$(18,7)}
8 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RAH$(25,3)}
9 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
Notes: {RAH$(28,15)}
10 ItemType. . . . . . . . . . . 1 SYN Item Type . . . . . . . . . . .
Valid:1,2,3,4,5 Notes:
1=Regular Item, 2=Special
Item, 3=Charge Item,
4=Comment Item, 5=Miscellaneo
us Item
11 ReceiptsDetailLineKey . . . . 6 SNN Receipts Detail Line Key. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RAH$(43,5)}
12 ActualInvoiceNo . . . . . . . 7 SYN Actual Invoice Number . . . . .INVOICE
FmtType:MASTERNUM Notes:
{RAH$(48,7)}
13 RMADetailLineKey. . . . . . . 6 SNN RMA Detail Line Key . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RAH$(55,5)}
14 SOPOBatchNo . . . . . . . . . 5 SNN SO/PO Batch Number. . . . . . .
Notes: {RAH$(60,5)}
15 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{RAH$(65,3)}
16 GeneratedDocumentNo . . . . . 7 SYN Generated Document Number . . .
Notes: {RAH$(68,7)}
17 RMALineKey. . . . . . . . . . 6 SNN RMA Line Key. . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {Packed) (RAH$(75,5)}
18 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
19 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
20 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL