Invoice Print Smart Fields

Over 80 smart fields are available to insert on an invoice during invoice design. These smart fields are named using an S prefix, followed by the table number, followed by the data type indication character, such as A (alpha), C (character), D (date), or N (numeric). For example, the smart field used to retrieve and print numeric information from the Business Unit Master table (F0006) is named SF0006N. A majority of the smart fields are used to retrieve information, which is stored in various tables, that you can print on the invoice. For each table that contains invoice-related information, smart fields are available and are used to:

• Retrieve and print alphabetic information.

• Retrieve single-character information.

• Retrieve date information.

• Retrieve numeric information.

• Print amounts from the Billing Detail Workfile table (F4812) and the Billing Workfile History table (F4812H).

• Print blocks of text.

• Calculate and print values based on other fields.

• Print accumulated values that have been stored in user-defined memory locations.

These smart fields can be used for retrieving table information and are available during invoice design:

Table	Table Name	Alpha Smart Field	Character Smart Field	Numeric Smart Field	Date Smart Field
F0006	Business Unit Master	SF0006A	SF0006C	SF0006N	SF0006D
F0014	Payment Terms	SF0014A	SF0014C	SF0014N	SF0014D
F0101	Address Book Master	SF0101A	SF0101C	SF0101N	SF0101D
F0111	Address Book - Who's Who	SF0111A	SF0111C	SF0111N	SF0111D
F0115	Address Book - Contact Phone Numbers	SF0115A	SF0115C	SF0115N	SF0115D
F0116	Address By Date	SF0116A	SF0116C	SF0116N	SF0116D
F03012	Customer Master By Line of Business	SF03012A	SF03012C	SF03012N	SF03012D
F0401	Supplier Master	SF0401A	SF0401C	SF0401N	SF0401D
F00692	Cost Center Supplemental Data Codes	SF0692A	SF0692C	SF0692N	SF0692D
F0901	Account Master	SF0901A	SF0901C	SF0901N	SF0901D
F1201	Asset Master File	SF1201A	SF1201C	SF1201N	SF1201D
F1721	Contract Detail	SF1721A	SF1721C	SF1721N	SF1721D
F4801	Work Order Master File	SF4801A	SF4801C	SF4801N	SF4801D
F4812	Billing Detail Workfile	SF4812A	SF4812C	SF4812N	SF4812D
F4822	Invoice Summary Work File	SF4822A	SF4822C	SF4822N	SF4822D
F48520	Invoice Summary Access	Not applicable (NA)	NA	SF48520N	NA
F5201	Contract Master	SF5201A	SF5201C	SF5201N	SF5201D
F5202	Contract Billing Line Detail	SF5202A	SF5202C	SF5202N	SF5202D
F5216	Milestone/Progress Billing Information	SF5216A	SF5216C	SF5216N	SF5216D
F4201	Sales Order Header File	NA	NA	SF4201N	NA
F00693	Cost Center Supplemental Data Text	SF0693A	NA	NA	NA
F4802	Work Order Instructions File	SF4802A	NA	NA	NA
F00165	Media Objects storage	SFABTXT SFCNTTXT SFINVTXT	NA	NA	NA
F0005	User Defined Codes	SF0005A	NA	NA	NA

Special smart fields that provide information not stored in tables are:

Smart Field	Smart Field - Name	Function
SFAMT	Amount	This smart field is used to print amounts from the F4812 and F4812H tables. It enables you to include or exclude burden and component amounts. It also works in conjunction with the Currency processing option in the Invoice Print program (R48504) to enable you to variably print foreign or domestic amounts.
SFADD	Calculate - Add	This smart field is used to add various fields and print the sum.
SFSUB	Calculate - Subtract	This smart field is used to subtract various fields and print the difference.
SFMUL	Calculate - Multiply	This smart field is used to multiply various fields and print the product.
SFDIV	Calculate - Divide	This smart field is used to divide various fields and print the quotient.
SFTOTAL	Register Total	This smart field is used to print the accumulated amounts on the field and to initialize the register (a variable memory location that the invoice designer can use to store and accumulate the value of the smart field), if desired.
SFCALC	Register Calculate	This smart field is used to perform calculations using multiple register values, and then print the result.