Business Process Automation
Business Number Type Defaults
The Business Number Generator (BNG) automatically generates and assigns sequential numbers to certain ID and other fields. This table describes the business number types that are generated by default. You can change and create business number types by using Business Number Type Management. The context for is defined by the business number type. You cannot change the default BN types to have a different context.
|
Field |
Business Number Type ID |
Context |
Default Setting |
Example |
|---|---|---|---|---|
|
Activity Time Definition |
ACTIVITY_TIME_DEF_XID |
EMPTY_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, 20070101-0002,.. |
|
Bill ID |
CUST_BILL_XID |
(none) |
CB— YYYYMMDD - four-digit number |
CB-20070101-0001, |
|
Bill Number (supplemental bills) |
SUPPLEMENTAL_BILL_NUMBER |
INVOICE_CONTEXT (for original bill) |
Original bill number with single letter sequence appended |
20050101-0001A, |
|
Bill of Lading Number |
BILL_OF_LADING |
SHIPMENT_CONTEXT |
Service Provider ID - six-digit number |
Service Provider-0001, |
|
Billable Transaction Sequence |
BTA_SEQUENCE_NO |
(none) |
YYYYMMDD - six-digit number |
20070101-000001, |
|
Bulk Continuous Move ID |
BULK_CM_XID |
(none) |
YYYYMMDD - four digit number |
20070101-0001, |
|
Bulk Plan ID |
BULK_PLAN_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Bulk Rating ID |
BULK_RATING_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Bulk Trailer Build ID |
BULK_TRAILER_BUILD_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Buyer ID / Customer ID / Location ID |
LOCATION_XID_BUYER |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Capacity Commitment ID |
CAPACITY_COMMITMENT_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Capacity Group ID |
CAPACITY_GROUP_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Capacity Limit ID |
CAPACITY_LIMIT.CAPACITY_LIMIT_XID |
CAPACITY_LIMIT_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Capacity Usage ID |
CAPACITY_USAGE.CAPACITY_USAGE_XID |
CAPACITY_USAGE_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Campaign ID |
GTM_CAMPAIGN_XID |
GTM_CAMPAIGN_CONTEXT |
YYYYMMDD-eight digit number |
20220524-00000001 |
|
Campaign Line ID |
GTM_CAMPAIGN_LINE_XID |
GTM_CAMPAIGN_CONTEXT |
CampaignID-six digit number |
20220524-00000001-000001 |
|
Charter Voyage ID |
CHARTER_VOYAGE_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Claim ID |
CLAIM_XID.DEFAULT |
change to (none) from Order Release Context - no order release passed in. |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Commercial Invoice ID |
COMMERCIAL_INVOICE_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Commercial Invoice Number |
COMMERCIAL_INVOICE_NUMBER |
ORDER_RELEASE |
Order release ID - four-digit number |
20070101-0003-0001 |
|
Compatibility Rule ID |
COMPAT_RULE_XID |
COMPAT_RULE_CONTEXT |
Compatibility rule XID, three digit number |
001, 002 |
|
Confirmation Number |
APPOINTMENT |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Consol ID |
CONSOL_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Consolidated Document ID |
CONSOLIDATED_DOCUMENT_XID | CONSOL_DOC_CONTEXT | Document Number - three-digit number | 111-001, 111-002, ... |
|
Container Group ID |
CONTAINER_GROUP_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Continuous Move Tour Name |
CM_NAME |
(none) |
five-digit number |
00001, 00002,... |
|
Customer Bill Number ** |
CUST_BILL_NUMBER |
Invoice Bill Number Context |
Service Provider ID - |
Service Provider-000001, |
|
Customer Bill Number ** |
MANUAL_CUST_BILL_NUMBER (only used for Job bills) |
(none) |
six-digit number |
000001, 000002,... |
|
Diag Log File |
DIAG_LOG_FILE_XID |
EMPTY_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Document ID |
DOCUMENT_XID |
DOCUMENT_DEF_CONTEXT |
five-digit number |
00001, 00002,... |
|
Document ID (Upload Document action on individual object) |
FILE_DOCUMENT_XID |
STRING_CONTEXT (passes file name in uppercase without extension) |
Uppercase file name (without file extension) - three-digit number |
FILENAME-001 |
|
Driver ID |
DRIVER_XID |
DRIVER_CONTEXT |
First letter of drivers first name followed by drivers last name, |
RSMITH |
|
Driver Calendar Event ID |
DRIVER_CALENDAR_EVENT_XID |
DRIVER_CALENDAR_EVENT_CONTEXT |
Driver XID - four digit number |
DRIVERNAME-0001 |
|
Equipment ID |
EQUIPMENT_XID |
EQUIPMENT_CONTEXT |
equipment XID-number is a concatenation of equipment initial hyphen equipment number (r*:id-l:xml=EQUIPMENT_INITIAL)-r*:xml=EQUIPMENT_NUMBER |
MAGX1018 |
|
Fleet Bulk Plan ID |
FLEET_BULK_PLAN_XID |
EMPTY_CONTEXT |
YYYYMMDD - |
20070101-0001, 20070101-0002,... |
|
Ground Schedule ID / Ground Service ID |
GROUND_SCHEDULE_GEN_XID |
GROUND_SERVICE_CONTEXT |
YYYYMMDD - |
20070101-0001, 20070101-0002,... |
|
Inventory ID |
GTM_TIP_INVENTORY_XID |
EMPTY_CONTEXT |
8 digit number |
|
|
Inventory Movement ID |
GTM_TIP_INV_MOVEMENT_XID |
EMPTY_CONTEXT |
8 digit number |
|
|
Invoice ID |
INVOICE_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Invoice Number (AutoPay)** |
AUTO_PAY_INVOICE_NUMBER |
Invoice Bill Number Context |
Service Provider ID - six-digit number |
Service Provider-000001, |
|
Item Origin ID |
ITEM_ORIGIN_XID |
ITEM_CONTEXT |
Item XID - four-digit number |
ITEM1 - 0001 |
|
Job ID |
JOB_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Job ID (Order Movement) |
JOB_XID_ORDER_MOVEMENT |
JOB_XID_ORDER |
Consol type ID - five digit number |
00001-00001 |
|
Job ID (Order Release) |
JOB_XID_ORDER_RELEASE |
JOB_XID_ORDER |
Consol type ID - "ORDER" - five-digit number |
00001-ORDER-00001 |
| Load Point Penalty Matrix ID | LOAD_POINT_PENALTY_MATRIX_XID | EMPTY_CONTEXT | YYYYMMDD - four digit number | 20231006-0001, 20231006-0002,... |
|
Location ID (via integration) |
LOCATION_XID_NO_CORP |
(none) |
five-digit number |
00001, 00002,... |
|
Location ID (via UI or the Create Location agent action) |
LOCATION_XID_WITH_CORP |
CORPORATION CONTEXT |
Corporation ID - four-digit number |
CORP-0002 |
|
Logistics Guide ID |
LOGISTICS_GUIDE_XID |
LOGISTICS_GUIDE _TEMPLATE_CONTEXT |
Logistics guide template ID - three-digit number |
LOG01-001 |
|
Master Air Waybill |
MAWB |
SHIPMENT_CONTEXT |
(none) |
|
|
Milestone ID |
MONITOR_AGENT_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Milestone Monitor ID |
MONITOR_PROFILE_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Order Base ID |
ORDER_BASE_XID |
INV_PARTY_CONTEXT _FOR_ORDER_BASE |
YYYYMMDD— |
20070101-0001, 20070101-0002,... |
|
Order Base Line ID |
OB_LINE_XID |
ORDER_BASE_CONTEXT |
Order Base ID - three-digit number |
20070101-0001-001, 20070101-0001-002,... |
|
Order Base Line Release Instruction ID |
OB_RELEASE_INSTR_XID |
OB_LINE_CONTEXT |
OB Line ID - release instruction sequence number |
20070101-0001-001-1 |
|
Order Base Ship Unit ID |
OB_SHIP_UNIT_XID |
ORDER_BASE_CONTEXT |
Order Base ID - three-digit number |
20070101-0001-001, 20070101-0001-002,... |
|
Order Base Ship Unit Release Instructions |
OB_SU_RELEASE_INSTR_XID |
OB_SHIP_UNIT_CONTEXT |
OB Ship Unit ID - release instructions sequence number |
20070101-0001-001-1 |
|
Order Movement ID |
ORDER_MOVEMENT_XID |
ORDER_MOVEMENT_CONTEXT |
(Primary/Default): Order release ID - three-digit number (Alternate): Parent order movement ID - three digit number |
20070101-0002-003-001 |
|
Order Release ID |
ORDER_RELEASE_XID |
Order Release From Base Context |
Order Base ID— |
20070101-0001-001 |
|
Order Release ID |
ORDER_RELEASE _XID_STANDALONE |
ORDER_RELEASE_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Order Release Line ID |
ORDER_RELEASE_LINE_XID |
ORDER_RELEASE_CONTEXT |
Order Release ID - three-digit number |
20070101-0001-001-001 |
|
Power Unit ID |
POWER_UNIT_XID |
POWER_UNIT_CONTEXT |
Power unit number |
|
|
Quote ID |
QUOTE_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Rate Offering ID |
RATE_OFFERING_XID |
RATE_OFFERING_CONTEXT |
{r*:xml=SERVPROV:substring=0,8:id=1}-{r*:xml=MODE:substring=0,9:id=2}-{r*:xml=EFFECTIVE:substring=0,4:id=3}-{nnn:contexts=1,2,3:start=1} |
CARRIER-TL-2010-001 [First 8 letters of service provider XID]-[First 9 letters of transport mode XID]-[rate version effective year]-[three-digit sequence] |
|
Rate Record ID |
RATE_GEO_XID |
RATE_OFFERING_CONTEXT |
Rate Offering ID - six-digit number |
rateoffering1-000001, |
|
Route Instance ID |
ROUTE_INSTANCE_XID |
ROUTE_TEMPLATE_CONTEXT |
Route template ID - three-digit number |
00001-001 |
|
Route Instance Leg ID |
ROUTE_INSTANCE_LEG_XID |
ROUTE_INSTANCE_CONTEXT |
Route instance ID - three-digit number |
00001-001-001 |
|
Route Template ID |
ROUTE_TEMPLATE_XID |
(none) |
five-digit number |
00001, 00002,... |
|
Route Template ID (Convert to Route Template Action) |
CR_ROUTE_TEMPLATE |
STRONG_CONTEXT (passes CR route XID) |
CR Route ID - three-digit number |
XXXX-001 |
|
Route Template Leg ID |
ROUTE_TEMPLATE_LEG_XID |
ROUTE_TEMPLATE_CONTEXT |
Route template ID - three-digit number |
00001-001 |
|
Shipment Group ID |
SHIPMENT_GROUP |
SHIPMENT_GROUP_CONTEXT |
Shipment Group Type ID - Order Owner involved party, or Shipment Group Type ID, or SHP_GRP_DATE_RULE |
GROUP-CONTACT, or GROUP, or 20070924-0001 |
|
Shipment Group ID (staged rule as default for SHIPMENT |
(none) (Staged rule used by SHIPMENT_GROUP.DEFAULT rule) |
SHIPMENT_GROUP_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Shipment ID* |
SHIPMENT_XID |
(none) |
five-digit number beginning with 01000 |
01000, 01001, 01002,... |
|
Shipment ID (for shipments created by the Create Appointment button) |
SHIPMENT_XID_FOR_APPOINTMENT |
EMPTY_CONTEXT |
APPOINTMENT-five-digit number |
APPOINTMENT-00001 |
|
Shipment Ship Unit ID |
S_SHIP_UNIT_XID |
S_SHIP_UNIT_CONTEXT |
Order release ship unit ID - three-digit number |
20070101-0001-001-001-001 |
|
Shipment Ship Unit ID (for shipments created by the Create Appointment button) |
S_SHIP_UNIT_XID_FOR_APPOINTMENT |
EMPTY_CONTEXT |
APPOINTMENT-five-digit number |
APPOINTMENT-00001 |
|
Shipping Agent Contact ID |
SHIPPING_AGENT_CONTACT_XID |
STRING_CONTEXT (passes Shipping Agent XID) |
Shipping agent ID - three-digit number |
SHIP-001 |
|
Shipping Agent Contact Profit ID |
SHIPPING_AGENT |
STRING_CONTEXT (passes Shipping Agent Contact XID) |
Shipping agent contact ID - three-digit number |
SHIP-001-001 |
|
Ship Unit ID |
SHIP_UNIT_XID |
ORDER_RELEASE_SHIP |
Order Base Ship Unit ID if not null. Otherwise Order Release ID - three-digit number |
20070101-0001-001-001 |
|
Transaction Line Qualification ID |
GTM_TRANS_LINE_QF_XID |
GTM_TRANSACTION_LINE_CONTEXT |
TransactionLine ID - 4 digit number |
TransLine-0001 |
|
Transmission External System Communication Info |
FTP_FILE_NAME |
FTP_CONTEXT |
Object GID - Interface Type - Six-digit number appended with ".xml" |
699308-SHIPMENT-000002.xml |
|
Voucher ID |
VOUCHER_XID |
(none) |
YYYYMMDD - four-digit number |
20070101-0001, |
|
Voucher Number |
VOUCHER_NUMBER |
INVOICE_CONTEXT |
Service Provider ID - six-digit number |
Service Provider-000001, |
|
Work Assignment |
WORK_ASSIGNMENT |
WORK_ASSIGNMENT_CONTEXT |
Resource Schedule Instance XID - Sequence Number |
{r*:id=1:xml=RESOURCE_SCHEDULE_INSTANCE} - {nnn:contexts=1:start=1} |
|
Work Assignment Bulk Plan |
WORK_ASSIGNMENT_BULK_PLAN_XID |
EMPTY_CONTEXT |
YYYYMMDD - four-digit number |
20070101-0001, 20070101-0002,... |
*The SHIPMENT_XID populates the Shipment ID field when shipments are generated only if the Value check box in the GENERATE SHIPMENT NAME parameter is marked.
** This context type is affected by the property glog.settlement.invoice.GenerateInvoiceNumberOnCreate. The default is True but may be set to False if you want to delay the generation of an invoice or bill number.
Related Topics
Configuring and Using the Business Number Generator
Business Number Rule Definitions
If you have any questions or comments about this documentation page, please Contact Oracle Documentation. 