Rules Engine Logical Tables

The following table provides a complete list (as of R316) of logical tables which may be referenced by Conditions or Actions within the Rules Engine.

Rules Engine Logical Table Name
Actual Table Name
Description
FB
FRGHT_BL
The Freight Bill currently in focus.
FXI
FXI
The Facsimile record for page 1 of the Facsimile for the Freight Bill currently in focus.
INVOICE
INVOICE
The invoice record related to the current Freight Bill.
INV_BAT
INV_BAT
The INV_BAT record related to the current Freight Bill.
VENDOR
VENDOR
The Vendor record associated with the batch being processed.
AC_B
VEND_AC
The Vendor Account record associated with the Billing Account on the Freight Bill (FB![ACCT_NUM_VEND_BLNG])
AC_O
VEND_AC
The Vendor Account record associated with the Origin Account on the Freight Bill (FB![ACCT_NUM_VEND_ORIG])
AC_D
VEND_AC
The Vendor Account record associated with the Destination Account on the Freight Bill (FB![ACCT_NUM_VEND_DEST])
A_LINE
A_LINE
The record which contains the original Assembly Line message related to the Freight Bill in focus. Because of string limitations, it is strongly recommended that this table only be used through the Asy_Fld function.
ORIG
LOC
The Location Record for the Origin location found by the location matching algorithm. (Candidate for future deimplementation)
DEST
LOC
The Location Record for the Destination location found by the location matching algorithm. (Candidate for future deimplementation)
PHYS_ORIG
PHYSLOC
The Physical Location Master record for the Origin location found by the location matching algorithm (possibly via an alias).
PHYS_DEST
PHYSLOC
The Physical Location Master record for the Destination location found by the location matching algorithm (possibly via an alias).
PHYS_ORIG_ALIAS
PHYSLOC
The Physical Location record for the Origin location found by the location matching algorithm. Based on the strength of the match, this could be an Alias or Master record.
PHYS_DEST_ALIAS
PHYSLOC
The Physical Location record for the Destination location found by the location matching algorithm. Based on the strength of the match, this could be an Alias or Master record.
AC_B_LOC
LOC
The Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_CA_Default
RCA_ELEM
The Reference Cost Allocation Record (type "Default") tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_CA
RCA_ELEM
The Reference Cost Allocation Record (type "Default") tied to the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_CA_In
RCA_ELEM
The Reference Cost Allocation Record (type "Inbound") tied to the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_CA_Out
RCA_ELEM
The Reference Cost Allocation Record (type "Outbound") tied to the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_T4_DEPT
DEPT
The Department record referenced in field %T004 of the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
ORIG_CA
RCA_ELEM
The Reference Cost Allocation Record (type "Default") tied to the Location Record for the Origin location found by the location matching algorithm. (Candidate for future deimplementation)
DEST_CA
RCA_ELEM
The Reference Cost Allocation Record (type "Default") tied to the Location Record for the Destination location found by the location matching algorithm. (Candidate for future deimplementation)
ORIG_ST
STATE_CD
The State Code Record tied to the Location Record for the Origin location found by the location matching algorithm. (Candidate for future deimplementation)
DEST_ST
STATE_CD
The State Code Record tied to the Location Record for the Destination location found by the location matching algorithm. (Candidate for future deimplementation)

Rules Engine Logical Table Name	Actual Table Name	Description
FB	FRGHT_BL	The Freight Bill currently in focus.
FXI	FXI	The Facsimile record for page 1 of the Facsimile for the Freight Bill currently in focus.
INVOICE	INVOICE	The invoice record related to the current Freight Bill.
INV_BAT	INV_BAT	The INV_BAT record related to the current Freight Bill.
VENDOR	VENDOR	The Vendor record associated with the batch being processed.
AC_B	VEND_AC	The Vendor Account record associated with the Billing Account on the Freight Bill (FB![ACCT_NUM_VEND_BLNG])
AC_O	VEND_AC	The Vendor Account record associated with the Origin Account on the Freight Bill (FB![ACCT_NUM_VEND_ORIG])
AC_D	VEND_AC	The Vendor Account record associated with the Destination Account on the Freight Bill (FB![ACCT_NUM_VEND_DEST])
A_LINE	A_LINE	The record which contains the original Assembly Line message related to the Freight Bill in focus. Because of string limitations, it is strongly recommended that this table only be used through the Asy_Fld function.
ORIG	LOC	The Location Record for the Origin location found by the location matching algorithm. (Candidate for future deimplementation)
DEST	LOC	The Location Record for the Destination location found by the location matching algorithm. (Candidate for future deimplementation)
PHYS_ORIG	PHYSLOC	The Physical Location Master record for the Origin location found by the location matching algorithm (possibly via an alias).
PHYS_DEST	PHYSLOC	The Physical Location Master record for the Destination location found by the location matching algorithm (possibly via an alias).

PHYS_ORIG_ALIAS	PHYSLOC	The Physical Location record for the Origin location found by the location matching algorithm. Based on the strength of the match, this could be an Alias or Master record.
PHYS_DEST_ALIAS	PHYSLOC	The Physical Location record for the Destination location found by the location matching algorithm. Based on the strength of the match, this could be an Alias or Master record.
AC_B_LOC	LOC	The Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_CA_Default	RCA_ELEM	The Reference Cost Allocation Record (type "Default") tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_CA	RCA_ELEM	The Reference Cost Allocation Record (type "Default") tied to the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_CA_In	RCA_ELEM	The Reference Cost Allocation Record (type "Inbound") tied to the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_CA_Out	RCA_ELEM	The Reference Cost Allocation Record (type "Outbound") tied to the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
AC_B_LOC_T4_DEPT	DEPT	The Department record referenced in field %T004 of the Location Record tied to the Vendor Account record associated with the Billing Account on the Freight Bill. (Candidate for future deimplementation)
ORIG_CA	RCA_ELEM	The Reference Cost Allocation Record (type "Default") tied to the Location Record for the Origin location found by the location matching algorithm. (Candidate for future deimplementation)
DEST_CA	RCA_ELEM	The Reference Cost Allocation Record (type "Default") tied to the Location Record for the Destination location found by the location matching algorithm. (Candidate for future deimplementation)
ORIG_ST	STATE_CD	The State Code Record tied to the Location Record for the Origin location found by the location matching algorithm. (Candidate for future deimplementation)
DEST_ST	STATE_CD	The State Code Record tied to the Location Record for the Destination location found by the location matching algorithm. (Candidate for future deimplementation)