New features added, version 7.5.2,7.5.3, 8.1
Program SPAN, Auto Number Control, is used to enter automatic numbering for customers, purchase orders, item masters, receivers, transfer orders, prospects, audits, checkpoints, general ledger journals, general ledger posting templates, model releases, product costing, service accounts payable batch, service line number, and service master.
* These numbers can be manual or automatic.
* If the number is left blank in the program where the record is created, the record type for which the number is left blank will be numbered automatically based on the numbers specified in program SPAN, Auto Number Control.
* The sequence names cannot include characters other than A to Z, _ (underscore), or 1 to 9.
Purchase orders and receivers were previously controlled by program POPM, PO / Receiving Parameter Maintenance. Item masters allowed auto numbering and creation of 12 digit UPC codes, but any special prefix had to be set by the installer. Transfer Order numbers were previously established in program IXPM, Stock Transfer Parameter Maintenance.
This program should not be run by synonym users as it will cause errors when using sequences.
Entering and Maintaining Auto Number Sequences
1. You can maintain the auto numbering sequences for the record types in this program.
2. You can change the maximum value for the field. The entry in this field must not exceed the number of characters allowed for the data type.
* Sales order and invoice number sequences are set up by the user with program SPON, Order and Invoice Number Control, but the sequences themselves must be modified in this program.
* Audit transaction numbers - 20 characters
* Bill of Lading - 10 characters
* Checkpoint - 16 characters
* Container Label - 30 characters
* Customer number - 10 characters
* General Ledger journal numbers - 12 characters
* General Ledger Posting Template - 10 characters
* Item Number - 20 characters
* Model Release number - 10 characters
* Program Change Request number - 6 characters
* Purchase order number - 10 characters
* Prospect number - 10 characters
* Receiver number - 10 characters
* Service AP batch number - 10 characters
* Service Line number - 10 characters
* Service transaction number - 10 characters
* Ship Label - 10 characters
* Transfer Order number - 9 characters
* Sales Order number - 12 characters
* Invoice number - 12 characters
3. You can change the starting number for the field, but you must be careful not to enter a starting value that will overlap previous existing values for the data type. The program does not check for duplicate values when sequences are created.
* The Last Value field displays the last value created for the record type through automatic numbering.
* To create the item numbers as United States standard 12 digit UPC codes, set the first 6 digits as the company, the next 5 digits as the product code and do not enter a twelfth digit. The program will calculate a twelfth digit as a check digit according to UPC rules.
4. You can change the cache size. Setting the cache size to 0 eliminates gaps in sequence numbers; any other value will cause gaps.
5. Set the cycle flag to on to have sequence number restart at the starting value when the max value is reached.
6. To have the record type use automatic numbering from this program, set the Active flag to on for the record type.
7. To recreate the sequence for the record type, press the [Re-Create Sequence] button.
AP1099_PYMT_SEQ Auto-assign payment sequence number for accounts payable 1099 payment records.
APFI_SEQ Auto-assign sequence numbers to the federal tax enterprise records in program APFI, Federal Enterprise Maintenance.
APVU_BATCH Auto-assign batch numbers in program APVU, Batch Voucher Upload from Flat File.
AP_BATCH Auto-assign AP batch numbers for API's.
AP_CHK_COM_SEQ
AP_DTL_TRX_XXX
AP_INVDC_SEQ
AP_INVHC_SEQ
AP_INV_RCVD
AP_MANUAL_C_SEQ
AP_MAN_CHK_SEQ
AP_TV_SEQ
ARALCAPBATCH Commissions payable batch number through program SMQM, Sales Representative Quota Maintenance.
ARMJ_SEQ
ARSC_SEQ
AR_BATCH Auto-assign AR batch numbers for API's.
ASSEMBLY
AUDIT Audit transaction numbering through program NADC, Audit Definition Control.
BCCOMM_SEQ
BC_SEQ
BILL_OF_LADING Bill of lading numbering in program OSLM, Bill of Lading Maintenance.
BONO_NOTIFY Sequence number for backorder notifications sent from program BONO, Back Order Notify.
CALL_RECORD_ID Sales representative call numbering in program PRSC, Sales Rep's Contact Sheet.
CCVN_BATCH
CCVN_TRANS
CHECKPOINT Menu checkpoints are used to track the programs that have been run for the restart job feature. This automatically numbers the programs as they are run.
CMDM_SEQ Auto-assign primary key sequence number for CMDM, Discount Level Maintenance, record.
CMPC_SEQ Auto-assign primary key sequence number for price matrix records.
CMSU_SEQ Auto-assign primary key sequence number for price matrix records.
COMMITMENT Commitment ID's generated for the Accounting for Commitments Interface.
CONTACT_SEQ Internal contact ID number for faster joins.
CONTAINER_LBL Container ID numbering in program OSCM, Staged Order Container Maintenance.
CONTR_COM_SEQ Auto-assign primary key sequence number for contract commission records.
CONTR_FCAST_SEQ Auto-assign primary key sequence number for contract forecast records.
CONTR_QTYS_SEQ Auto-assign primary key sequence number for contract quantity break records.
CONTR_REL_SEQ Auto-assign primary key sequence number for contract release records.
CON_PHONE_SEQ Contact telephone number sequencing in program SPWM, System Contacts Maintenance, and other programs in which contacts can be entered.
CPP_SEQ
CUSTOMER Customer numbering in program CMMM, Customer Master Maintenance.
CUST_CON_SHR
CUST_EVE_SHR
CUST_OE_SEQ
CUST_REPS
CUST_SHIP_AC_SEQ
DEBUG
EDI_RUN_SEQ
ES_SPEC_SEL_SEQ
FAST_RECEIVE Receipt number for item receipts entered in program REFS, Miscellaneous Receipts.
FIN_RATES_SEQ Auto-assign primary key sequence number for financial rate records.
GEN
GLAPD_SEQ
GLHB_DETAIL_SEQ Auto-assign primary key sequence number for detail records in program GLHB, Balance Sheet Analyzer.
GLHB_RESULT_SEQ Auto-assign primary key sequence number for result records in program GLHB, Balance Sheet Analyzer.
GLHB_USER_SEQ Auto-assign primary key sequence number for user record in program GLHB, Balance Sheet Analyzer.
GL_FISC_PER_ID Fiscal Period ID in program GLFM, Fiscal Period Maintenance.
GL_FPU_SEQ
GL_JE Internal journal numbering through program GLJP, GL Journal Transaction Posting.
GL_POST_TEMPL Posting template automatic numbering through program GPTM, Posting Template Maintenance and program GPTE, Posting Template Value Entry.
GLOBAL_INV Invoice numbering in program ARIE, One Step Invoice Entry, and program OESC, Shipping Confirmation, if selected in program SPON, Order and Invoice Number Control.
GLOBAL_ORDERS Sales Order numbering in program ARIE, One Step Invoice Entry, and program OESC, Shipping Confirmation, if selected in program SPON, Order and Invoice Number Control.
GRANTS Used by upgrades scripts.
GTIN_XX The GTIN code for items created in program ICMM, Inventory Master Maintenance, where the XX is the logged in plant code. This sequence must be manually created by the user for each plant in which GTIN codes will be generated for items.
IAL_BATCH_SEQ Inventory adjustment batch numbering with program ICBM, Inventory Bulk Moves and program ICIA, Inventory Adjustments.
ICCR_SEQ Auto-assign primary key sequence number for records entered in program ICCR, Customer / Item Cross Reference Maintenance.
IMAGE Image numbering with the NDS Imaging Feature.
IMEM_SEQ Auto-assign primary key sequence number for records entered in IMEM, Item Default Location Maintenance.
INFO_SEQ
IP_SEQ
ITEM_MASTER Item numbering in program ICMM, Inventory Master Maintenance.
JOB_BILLING Internal billing calculations with program PMBM, Project Billing, use this number. It is the primary key to the job_billing_detail table.
JOB_LOG_SEQ The job logging sequence used in program JOBQ, NDS Job Queue Management.
JOB_NO Job schedule numbers in program JOBQ, NDS Job Queue Management.
JOB_NO_PM Project numbers for program PMMM, Project Management Maintenance.
JOB_SCHEDULE Auto-assign primary key sequence number for project scheduling.
LABOR_DETAIL_PL Auto assigns primary key sequence number for labor entries.
LEAD Lead numbers for lead records imported in program LEMM, Lead Master Maintenance.
LEAD_QA_TEMPL Auto-assign lead survey template numbers.
LS_ID_SEQ Load sheet ID numbering in program LSEM, Load Sheet Maintenance.
MAIL_ADDR_SEQ Mail To ID numbering in program MTMM, Mail To/Prospect Input for Catalogs.
MODEL_RELEASE Model release numbering in program MOCF, Modular Bill Configuration, through program OEOE, Sales Order Entry Maintenance.
NDS_COLUMNS
NDS_FKEYS
NDS_KEYS
NDS_SEND_TO
NDS_SEQUENCES
NDS_SOFT_OBJ
NDS_TABLES
NONSTK_SEQ
OETRACK Auto-assign primary key sequence number for sales order tracking records.
OE_BO_SEQ
OE_LINE_COM Auto-assign primary key sequence number for sales order line comments.
OE_REF_NO AR internal reference number, moved from OE_CONTROL. Used for program OESJ, Sales Orders End of Day & Journals, program ARAD, AR Adjustments Entry, and program ARPE, Cash Receipts Entry.
OE_SEND_TO Auto-assign primary key sequence number for sales order send to records (mail/fax).
OE_SUB_NO AR internal reference number, moved from OE_CONTROL. Used for program OESJ, Sales Orders End of Day & Journals, program ARAD, AR Adjustments Entry, and program ARPE, Cash Receipts Entry.
OPX_SEQ
PCR Program change request sequence numbering in program UTPC, Program Change Request Entry/Maintenance, and program SUPP, Customer Support Request.
PCR_ASS_SEQ Assignation numbering for program change request assignations in program UTPC, Program Change Request Entry/Maintenance, and program SUPP, Customer Support Request.
PC_SEQ
PF_SEQ
PLORD
PO Purchase order numbering in program POEM, P.O. Entry/Maintenance.
POD_COMM_SEQ
POH_COMM_SEQ
PO_DIST_SEQ
PPH_CHARGES_SEQ
PROSPECT Prospect numbering in program PRMM, Prospect Master Maintenance.
PULL_CARD
QT
QUEUE
RECEIVER Receiver numbering in program REEM, Receiver Entry/Maintenance, and program REOM, One Step Receiver Entry/Maintenance.
RECON_ID Bank reconciliation number in program BRMM, Bank Reconciliation.
ROLLOUT Automatic rollout ID numbering in program OERO, Order Entry Rollout Maintenance
RS_SEQ
RTMPLT_DETL
RTTMPLT_DETL
RTV_NO Return to vendor transaction numbering in program RTVM, Return to Vendor Maintenance.
SALES_TAX_DETL
SALES_TAX_RATE
SCHEDULE_TRANS Job queue internal job ID in JOBQ.
SCRAP_HIST
SEND_TO
SERVICEAPBATCH Accounts Payable Batch numbering when vouchers are created through program SVMM, Service Master Maintenance.
SERVICEMASTER Service transaction numbering through program SVMM, Service Master Maintenance.
SHIPTO_REPS
SHIP_LABEL Label ID numbering in program OSCM, Staged Order Container Maintenance.
SHIP_LOC_SEQ
SPOP_SEQ
SR_PK_SEQ
SV_COMM_SEQ
SV_LINE_COM
SV_REP_COM
SV_RET_COM
TD_COM_SEQ
TEMPL_DETL
TEMP_FILE For creating files for transmission on UNIX servers.
TOOL_TRANS
TRANSFER_ORD Automatic numbering of transfer orders through program IXAR, Create Stock Transfer Orders, program IXEM, Stock Transfer Order Maintenance, and program IXAM, Transfer Order Administrative Maintenance.
UVW_PK_SEQ
VC_SEQ
VEMC_KEY_SEQ
VENDOR Vendor number generation for API's and program VEMM, Vendor Master Maintenance.
VENDOR_PRICE
VISANET_BATCH
VISANET_TRANS
VMV_SEQ
VUTM
VUTM_COL_PK
WFLOW_HIST_SEQ Sequence number for archiving workflow events.
WOTRACK
Order and invoice numbering can be set up with custom names by the user through program SPON, Order and Invoice Number Control.
Usage comments are used to define the usage of specific record types in program SPAN, Auto Number Control,, and can be accessed by clicking on the [Comments] 
button or the [Zoom] 
button.
Usage comment records are created automatically for each record type. New records cannot be created here.
1. Query the record type value for which you wish to view or maintain the usage comment.
2. In the Documentation/Comments field, enter the desired text for the comment.
3. When all changes have been made, press [Commit].
Press this button to view and maintain usage comments for all record types. See the Viewing and Maintaining Record Type Usage Comments for more information.
Press this button to change the re-create the sequence numbers. This may cause the overlap of sequence numbers if the record type has already been used.
Press this button to remove the sequence from the database.
Press this button to view and maintain usage comments for the currently selected record type. See the Viewing and Maintaining Record Type Usage Comments for more information.