BC_HeaderRejection BC Header Rejection Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BC_HeaderRejection_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/BC"+%C$+"/BC_HeaderRejection.M4T"
KPRIMARY: SessionKey+UserID+HeaderKey KTYPE: BCTransactionCode+SessionKey+UserID+HeaderKey KDATE: TransactionDate+SessionKey+UserID+HeaderKey
Fld Column Name M/L TUR Description/Notes Class
1 SessionKey. . . . . . . . . . 6 SNY Session Key . . . . . . . . . . FmtType:CHARNUM 2 UserID. . . . . . . . . . . . 3 SNY User ID . . . . . . . . . . . . 3 HeaderKey . . . . . . . . . . 6 SNY Header Key. . . . . . . . . . . FmtType:ZEROFILL 4 BCTransactionCode . . . . . . 3 SNY Transaction Type. . . . . . . . Valid:11,12,13,14,15,16,21, 22,23,31,41,42,51,52,53,54, 55 5 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 6 Processing. . . . . . . . . . 1 SNN Processing. . . . . . . . . . . DfltVal:3 Valid:0,1,2,3,4 7 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM DepVal:REQUIR ED 8 SOInvoiceNo . . . . . . . . . 7 SYN SO Invoice Number . . . . . . .INVOICE FmtType:MASTERNUM 9 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO FmtType:CHARNUM DepVal:REQUIR ED 10 APInvoiceNo . . . . . . . . . 10 SYN AP Invoice Number . . . . . . .APINVOICE 11 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 12 BatchNo . . . . . . . . . . . 5 SYN Batch No. . . . . . . . . . . .BATCHNO FmtType:ALPHANUM 13 ShipperID . . . . . . . . . . 3 SYN Shipper ID. . . . . . . . . . .SHIPPERID DepVal:REQUIRED 14 ShipVia . . . . . . . . . . . 15 SYN Shipping Code . . . . . . . . .SHIPCODE 15 WarehouseCode . . . . . . . . 3 SYN Warehouse . . . . . . . . . . .WAREHOUSE FmtType:CHARNUM 16 ToWarehouseCode . . . . . . . 3 SYN To Warehouse. . . . . . . . . .WAREHOUSE FmtType:CHARNUM 17 BillNo. . . . . . . . . . . . 30 SNN Bill Number . . . . . . . . . .BILLNO DepVal:REQUIRED 18 Revision. . . . . . . . . . . 3 SNN Revision. . . . . . . . . . . .REVISION FmtType:CHARNUM 19 BillLotNoOrStartingSerialNo . 15 SYN Bill Production Lot Number or S 20 BillOptions . . . . . . . . . 35 SNN Options . . . . . . . . . . . . 21 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 22 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC DepVal:REQ UIRED 23 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . .CHECKNO 24 InvoicePaymentAmt . . . . . . 13.2 NNN Invoice Payment Amount AmountPoAMOUNT Mask:###,###,###.00 25 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL 26 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM 27 RejectionNo . . . . . . . . . 4 SNN Rejection Number. . . . . . . . Read Only:Y FmtType:ZEROFILL 28 ProductionQuantity. . . . . . 16.6 NNN Production Quantity . . . . . .QUANTITY Mask:##,###,###.000000- 29 MD_Hdr_S1 . . . . . . . . . . 30 SNN MD Header String1 . . . . . . . 30 MD_Hdr_S2 . . . . . . . . . . 30 SNN MD Header String2 . . . . . . . 31 MD_Hdr_S3 . . . . . . . . . . 30 SNN MD Header String3 . . . . . . . 32 MD_Hdr_S4 . . . . . . . . . . 30 SNN MD Header String4 . . . . . . . 33 MD_Hdr_S5 . . . . . . . . . . 30 SNN MD Header String5 . . . . . . . 34 MD_Hdr_N1 . . . . . . . . . . 16.6 NNN MD Header Number1 . . . . . . . 35 MD_Hdr_N2 . . . . . . . . . . 16.6 NNN MD Header Number2 . . . . . . . 36 MD_Hdr_N3 . . . . . . . . . . 16.6 NNN MD Header Number3 . . . . . . . 37 MD_Hdr_N4 . . . . . . . . . . 16.6 NNN MD Header Number4 . . . . . . . 38 MD_Hdr_N5 . . . . . . . . . . 16.6 NNN MD Header Number5 . . . . . . . 39 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 40 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . Read Only:Y 41 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 42 DateUpdated . . . . . . . . . 8 SNY Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 43 TimeUpdated . . . . . . . . . 8 SNY Time Updated. . . . . . . . . . Read Only:Y 44 UserUpdatedKey. . . . . . . . 10 SYY User. . . . . . . . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL