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