AR_DeleteChangeCustomersWork AR Delete Change Customers Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_DeleteChangeCustomersListing_rpt,AR_DeleteChangeCustomersLog_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_DeleteChangeCustomersWork.M4T"
KPRIMARY: Operation+LineNo+SequenceNo KSOURCECUSTOMER: SourcePrefix+SourcePrimary+DestinationPrefix+DestinationPrimary+LineNo
Fld Column Name M/L TUR Description/Notes Class
1 LineNo. . . . . . . . . . . . 14 SNY Line Number . . . . . . . . . . 2 SequenceNo. . . . . . . . . . 14 SNN Sequence Number . . . . . . . . 3 SourcePrefix. . . . . . . . . 2 SYN Source AR Division Number . . .ARDIVISION Mask:00 4 SourcePrimary . . . . . . . . 20 SYY Source Customer Number. . . . .CUSTOMERNO 5 DestinationPrefix . . . . . . 2 SYN Destination AR Division Number.ARDIVISION Mask:00 6 DestinationPrimary. . . . . . 20 SYY Destination Customer Number . .CUSTOMERNO 7 ChangeStatus. . . . . . . . . 1024 SNN Change Status . . . . . . . . . 8 Operation . . . . . . . . . . 1 SYN Operation . . . . . . . . . . . Valid:0,1,2 Notes: 0=Skip, 1=Delete, 2=Change 9 AllFiles. . . . . . . . . . . 1 SNN All Files . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 10 DeleteRepetitiveInvoices. . . 1 SYN Delete Repetitive Invoices. . .YESNO DfltVal:N Valid:Y,N 11 DeleteContacts. . . . . . . . 1 SYN DeleteContacts. . . . . . . . .YESNO DfltVal:N Valid:Y,N 12 DeleteCreditCards . . . . . . 1 SYN Delete Credit Cards . . . . . .YESNO DfltVal:N Valid:Y,N 13 DeleteEBMCreditCards. . . . . 1 SYN Delete EBM Credit Cards . . . .YESNO DfltVal:N Valid:Y,N 14 DeleteSalesOrders . . . . . . 1 SYN Delete Sales Orders . . . . . .YESNO DfltVal:N Valid:Y,N 15 DeleteShipTo. . . . . . . . . 1 SYN Delete Ship To. . . . . . . . .YESNO DfltVal:N Valid:Y,N 16 DeleteEBMCustomer . . . . . . 1 SNN Delete EBM Customer . . . . . .YESNO DfltVal:N Valid:Y,N 17 DeleteRMA . . . . . . . . . . 1 SNN Delete RMA. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 18 StartingARDivisionNo. . . . . 2 SNN Starting AR Division Number . .ARDIVISION Mask:00 19 StartingCustomerNo. . . . . . 20 SNN Starting Customer Number. . . .CUSTOMERNO 20 EndingARDivisionNo. . . . . . 2 SNN Ending AR Division Number . . .ARDIVISION Mask:00 21 EndingCustomerNo. . . . . . . 20 SNN EndingCustomerNo. . . . . . . .CUSTOMERNO 22 NewARDivisionNo . . . . . . . 2 SNN New AR Division Number. . . . .ARDIVISION Mask:00 23 NewCustomerNo . . . . . . . . 20 SNN New Customer Number . . . . . .CUSTOMERNO