1. Contract and Service Billing Implementation Guide
  2. Smart Fields

Smart Fields

This table shows the smart fields that are available to insert on an invoice during invoice design. It also shows the parameter prompts that the invoice designer must answer when inserting these smart fields:

Smart Field

Source Table

Parameters

Explanation

SF0006x (where x equals A (alpha), C (character), D (date), or N (numeric))

Business Unit Master (F0006)

1

R01PCC. Use this parameter to retrieve information from the Business Unit Master table (F0006).

SF0014x (where x equals A, C, D, or N)

Payment Terms (F0014)

1

R01PPT. Use this parameter to retrieve information from the Payment Terms table (F0014).

SF0101x (where x equals A, C, D, or N)

Address Book Master (F0101)

1

R01PAB. Use this parameter to retrieve information from the Address Book Master table (F0101).

SF0111x (where x equals A, C, D, or N)

Address Book - Who's Who (F0111)

1

R01PWW. Use this parameter to retrieve information from the Address Book - Who's Who table (F0111).

SF0115x (where x equals A, C, D, or N)

Address Book - Contact Phone Numbers (F0115)

1

R01PPN. Use this parameter to retrieve information from the Address Book - Contact Phone Numbers table (F0115).

5

R22P. Use this parameter to specify how the system displays the billing phone number.

SF0116x (where x equals A, C, D, or N)

Address by Date (F0116)

1

R01PAD. Use this parameter to retrieve information from the Address by Date table (F0116).

5

R23P. Use this parameter to specify whether the system overrides the previously entered data item and displays a specified format of the complete address.

SF03012x (where x equals A, C, D, or N)

Customer Master by Line of Business (F03012)

1

R01PCM. Use this parameter to retrieve information from the Customer Master by Line of Business table (F03012).

SF0401x (where x equals A, C, D, or N)

Supplier Master (F0401)

1

R01PSP. Use this parameter to retrieve information from the Supplier Master table (F0401).

SF0692x (where x equals A, C, D, or N)

Cost Center Supplemental Data Codes (F00692)

1

R01PSC. Use this parameter to retrieve information from the Cost Center Supplemental Data Codes table (F00692).

5 (SF0692N Only)

R25P. Use this parameter to identify a register for storing retrieval code information.

SF0901x (where x equals A, C, D, or N)

Account Master (F0901)

1

R01PAM. Use this parameter to retrieve information from the Account Master table (F0901).

SF0693A

Cost Center Supplemental Data Text (F00693)

1

R05P. Use this parameter to specify whether the system prints business unit information associated with the job, the home business unit, or the project entered on the job master.

2

R26P. Use this parameter to enter the data type associated with the first column of the supplemental data item to retrieve.

3

R18P. Use this parameter to specify the value associated with the first column of the supplemental data item to retrieve.

4

R27P. Use this parameter to specify the number that relates to the position in the text that will be the beginning character to be printed on this line on the invoice. This parameter works in conjunction with R28P.

5

R28P. Use this parameter to control the printing of text on the invoice. This parameter works in conjunction with R27P.

SF1201x (where x equals A, C, D, or N)

Asset Master File (F1201)

1

R01PEQ. Use this parameter to retrieve information from the Asset Master File table (F1201).

SF1721x (where x equals A, C, D, or N)

Contract Detail (F1721)

1

R01PCD. Use this parameter to retrieve information from the Contract Detail table (F1721).

SF4201N

Prepayment Transaction Table (F004201)

1

R29P. Use this parameter to specify whether the system prints the prepayment amount for a CSMS service contract for a specific line number or for the entire invoice.

2

R25P. Use this parameter to specify a register for storing retrieval code information.

SF4801x (where x equals A, C, D, or N)

Work Order Master File (F4801)

1

R01PWO. Use this parameter to retrieve information from the Work Order Master File table (F4801).

SF4802A

Work Order Instructions File (F4802)

1

R06P. Use this parameter to associate a work order description with a work order record type.

2

R27P. Use this parameter to specify the number that relates to the position in the text that will be the beginning character to be printed on this line on the invoice. This parameter works in conjunction with R28P.

3

R28P. Use this parameter to control the printing of text on the invoice. This parameter works in conjunction with R27P.

SF4812x (where x equals A, C, D, or N)

Billing Detail Workfile (F4812)

Billing Workfile History (F4812H)

1

R01PBD. Use this parameter to retrieve information from the Billing Detail Workfile table (F4812).

SF4822x (where x equals A, C, D, or N)

Invoice Summary Work File (F4822)

1

R01PIS. Use this parameter to retrieve information from the Invoice Summary Work File table (F4822).

SF48520N

Invoice Summary Access (F48520)

1

R01PSA. Use this parameter to retrieve information from the Invoice Summary Access table (F48520).

2

R12P. Use this parameter to specify whether to summarize the total amount billed to date. If you specify that the amount be summarized, you can also specify whether the system summarizes by contract number, change order, or owner pay item.

3

R13P. Use this parameter to specify the level of summarization, by account number, that the system summarizes the total amount billed to date.

4

R14P. Use this parameter to specify whether to include the employer or supplier number in the criteria for summarizing the total amount billed to date.

5

R16P. Use this parameter to control how the system prints amounts that are associated with specific component codes.

6

R25P. Use this parameter to identify a register for storing retrieval code information.

SF5201x (where x equals A, C, D, or N)

Contract Master (F5201)

1

R01PCBM. Use this parameter to retrieve information from the Contract Master table (F5201).

SF5202x (where x equals A, C, D, or N)

Contract Billing Line Detail (F5202)

1

R01PCBD. Use this parameter to retrieve information from the Contract Billing Line Detail table (F5202).

SF5216x (where x equals A, C, D, or N)

Milestone/Progress Billing Information (F5216)

Milestone/Progress Billing Line Cross Reference Details (F52161)

1

R01PMP. Use this parameter to retrieve information from the Milestone/Progress Billing Information table (F5216).

SFAMT

No source table

1

R04P. Use this parameter to specify the inclusion of various amounts, such as unit price, revenue total, taxable amount, and discount available, within the invoice.

Amounts

2

R08P. If the amounts to be printed represent a summarization of detail lines, use this parameter to specify whether the system prints the labor or burden component contained within the total.

3

R16P. Use this parameter to specify whether the system prints amounts that are associated with specific component codes.

4

R25P. Use this parameter to specify a register for storing retrieval code information.

SFABTXT

Media Object storage (F00165)

1

R02P. Use this parameter to specify which address book number the system uses to retrieve address book information.

2

R03P. Use this parameter to specify whether the system uses an alternate address book number. If you allow an alternate number, you can specify which one.

3

R27P. Use this parameter to specify the number that relates to the position in the text that will be the beginning character to be printed on this line on the invoice. This parameter works in conjunction with R28P.

4

R28P. Use this parameter to control the printing of text on the invoice. This parameter works in conjunction with R27P.

SFCNTTXT

Media Object storage (F00165)

1

R30P. Use this parameter to specify which level of text to print. (This parameter is for use in Contract Billing only.)

2

R27P. Use this parameter to specify the number that relates to the position in the text that will be the beginning character to be printed on this line on the invoice. This parameter works in conjunction with R28P.

3

R28P. Use this parameter to control the printing of text on the invoice. This parameter works in conjunction with R27P.

SFINVTXT

Media Object storage (F00165)

1

R15P. Use this parameter to specify which level of text within a batch of invoices to print.

2

R27P. Use this parameter to specify the number that relates to the position in the text that will be the beginning character to be printed on this line on the invoice. This parameter works in conjunction with R28P.

3

R28P. Use this parameter to control the printing of text on the invoice. This parameter works in conjunction with R27P.

SFADD

No source table

1-4

R24P. Use this parameter to specify previously defined report variables.

SFSUB

SFMUL

SFDIV

Add/Subtract/Multiply/Divide

Calculations

SFTOTAL

No source table

1

R10P. Use this parameter to specify which of the 99 registers (rolling total amounts) the system prints.

Register Total

2

R11P. Use this parameter to control whether the system clears the selected register so that it equals zero.

3

R25P. Use this parameter to identify a register for storing retrieval code information.

SF005A

User Defined Codes (F0005)

1

R31P. Use this parameter in conjunction with the parameter associated with the user-defined code Table Type prompt to specify the destination user-defined code table.

2

R32P. Use this parameter in conjunction with the parameter associated with the user-defined code Product Code prompt to specify the destination user-defined code table.

3

R33P. Use this parameter to select a previously defined report variable using a drop-down list box. The selected report variable should contain a value that is associated with a defined UDC table.

4

R35P. Use this parameter to specify the data dictionary item that the system uses to derive the destination user-defined code table using the associated user-defined product code and record type.

SFCALC

No source table

1

R34P. Use this parameter to enter the equation that the system uses to calculate and display a value by performing operations on values stored in multiple registers.

Register Calculate

2

R25P. Use this parameter to identify a register for storing retrieval code information.