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