Optional Fields Used by the Accounts Receivable System

This table lists fields in the F03012Z1 that are optional and are used by the Accounts Receivable system. You can use these fields to provide additional information about a transaction.

Field Name	Alias	Type	Length	Definition
Type - Transaction	VOTYTN	Alpha	2	A value that identifies the type of transaction. If you leave this field blank, the system uses the value in the transaction type processing option in the Customer Master MBF (P0100042), if set up.
Direction Indicator	VODRIN	Alpha	1	A number that identifies whether a batch job is inbound or outbound processing. For inbound processing, enter 0. For outbound processing, leave this field blank. The system updates this field with 1 if the record is a "before image" and 2 if the record is an "after image." A processing option in the Customer Master MBF (P0100042) determines whether a before image is written to the table. This system uses this field for data selection for the batch upload programs, and searches for a value of 0 to avoid uploading records that are for outbound processing.
EDI - Detail Lines Processed	VOEDDL	Number	5	A number that represents the number of detail lines included in a specific transaction. This field is informational only.
Trading Partner ID	VOPNID	Alpha	15	A value used in an Electronic Data Interchange (EDI) transaction to identify who is trading documents with you.
G/L Offset	VOARC	Alpha	4	A value that, in conjunction with the VOCO field, determines the A/R trade offset account to which the transaction will be posted. The account established in the AAI PCxxxx (where xxxx= the value in the G/L Offset field) will be used the post process. You do not need to complete this field unless you want to direct different transactions to different offset accounts.
Business Unit - A/R Default	VOMCUR	Alpha	12	A number that, in conjunction with the VOOBAR and VOAIDR fields, defines a revenue account that is used when you enter an invoice. Do not enter a value in this field if you complete the fields for a model journal entry (VOCKOR, VODCAR, VODTAR). The revenue account assigned to the model journal entry overrides the value entered in this field.
Object - A/R Default	VOOBAR	Alpha	6	A number that, in conjunction with the VOMCUR and VOAIDR fields, defines a default revenue account that is used when you enter an invoice. Do not enter a value in this field if you complete the fields for a model journal entry (VOCKOR, VODCAR, VODTAR). The revenue account assigned to the model journal entry overrides the value entered in this field.
Subsidiary - A/R Default	VOAIDR	Alpha	8	A number that, in conjunction with the VOOBAR field, defines a default revenue account that is used when you enter an invoice. Do not enter a value in this field if you complete the fields for a model journal entry (VOCKOR, VODCAR, VODTAR). The revenue account assigned to the model journal entry overrides the value entered in this field.
Document Company - A/R Model	VOKCOR	Alpha	5	A number that, in conjunction with the VODCAR and VODTAR fields, defines a default revenue account that is used when you enter an invoice. Do not specify a model journal entry if you complete the fields for a default revenue account (VOMCUR, VOOBAR, VOAIDR). The model journal entry overrides the default revenue account.
Document Number - A/R Model	VODCAR	Alpha	8	A number that, in conjunction with the VOKCOR and VODTAR fields, defines a default revenue account that is used when you enter an invoice. The system does not validate the values you enter. Do not specify a model journal entry if you complete the fields for a default revenue account (VOMCUR, VOOBAR, VOAIDR). The model journal entry overrides the default revenue account.
Document Type - A/R Model	VODTAR	Alpha	2	A number that, in conjunction with the VOKCOR and VODCAR fields, references a model journal entry that is used when an invoice is entered. The system does not validate the values you enter. Do not specify a model journal entry if you complete the fields for a default revenue account (VOMCUR, VOOBAR, VOAIDR). The model journal entry overrides the default revenue account.
Currency Code	VOCRCD	Alpha	3	This field displays only if multicurrency is activated. A value that indicates the default currency to use for this customer when you enter an invoice. The value that you enter in this field must exist in the F0013 table. If you leave this field blank, the system uses the currency associated with the company entered on the invoice.
Tax Rate Area	VOTXAI	Alpha	10	A value that indicates the default tax rate area used in invoices for this customer. The value that you enter in this field must exist in the Tax Areas table (F4008).
Tax Explanation Code	VOEXR1	Alpha	2	A value that indicates the default tax explanation code the system uses for invoices that you enter for this customer. The value that you enter in this field must exist in UDC table 00/EX (Tax Explanation Codes).
Amount - Credit Limit	VOACL	Number	15	A value that indicates the credit limit in a format that your database accepts. Some databases accept a decimal identifier. To update this field, a credit manager must set it up and workflow processing must be deactivated. If workflow processing is not deactivated, a message is sent to the person referenced in the VOCMG field to approve the credit limit, and the system does not update the field. Credit limit approval is activated in the workflow process by default.
Hold Invoices	VOHDAR	Alpha	1	A code that allows you to hold all invoices for the customer. Values are: Y: Hold invoices. Do not allow entry of new invoices. Sales orders and receipts can still be entered. N: Do not hold invoices. Allow entry of new invoices. If you leave this field blank, the system uses N.
Payment Terms	VOTRAR	Alpha	3	A value that defines the payment terms for customer invoices. The value that you enter in this field must exist in the Payment Term table (F0014).
Send Statement To	VOSTTO	Alpha	1	A code that indicates the address to which statements are sent. Values are: C: Customer P: Parent 1: First Address Number 2: Second Address Number 3: Third Address Number 4: Fourth Address Number 5: Fifth Address Number 6: Sixth Address Number (Special Factor/Payee)
Payment Instrument	VORYIN	Alpha	1	A code that specifies how payments are made to the customer. The value that you enter in this field must exist in UDC table 00/PY (Payment Instrument).
Print Statement (Y/N)	VOSTMT	Alpha	1	A code that indicates whether the customer is eligible to receive a statement or invoice. The default (Y) prints the invoice or statement.
Alternate Payor	VOARPY	Alpha	1	A person or company other than the customer assigned to the PYR field. If you leave this field blank, the system updates it with the customer number when the record is processed. The value you enter in this field must exist in the F0101 table.
Auto Receipt (Y/N)	VOATCS	Alpha	1	A code to indicate whether receipts from this customer can be processed using auto cash (lock box). If you leave this field blank, the system updates this field with Y when the record is processed.
Send Invoice To	VOSITO	Alpha	1	A code that indicates the address to which invoices are sent. Values are: C: Customer P: Parent 1: First Address Number 2: Second Address Number 3: Third Address Number 4: Fourth Address Number 5: Fifth Address Number 6: Sixth Address Number (Special Factor/Payee)
Statement Cycle	VOCYCN	Alpha	2	A code that identifies a certain time in which statements are printed for customers. You can also use this code to indicate a specific billing cycle. If you leave this field blank, the system populates it with the first initial of the customer's alpha name when the record is processed.
Temporary Credit Message	VOTSTA	Alpha	2	A code that indicates a temporary credit condition for the customer. The value that you enter in this field must exist in UDC table 01/CM (Credit Messages).
Date of Last Credit Review	VODLC	Date	6	The date of the last credit review for the customer. Use a format that your database accepts. Some databases allow you to enter the date in a Gregorian date format (mmddyy or yymmdd) while others might require a Julian date format. The Julian date format is cyyddd (where c = century). Enter 1 for the century to indicate transactions in the 21st century. For example, the date 6/1/01 corresponds to a Julian date 101152. For 6/1/00, the corresponding Julian date is 100153 (because the year 2000 has a leap day, 2/29/00).
Delinquency Notice (Y/N)	VODNLT	Alpha	1	A code that indicates whether the customer is eligible to receive delinquency notices. Blank indicates that the customer is eligible to receive delinquency notices.
Person Completing Last Credit Review	VOPLCR	Alpha	10	A code that indicates the person who completed the last credit review for the customer. The value that you enter is not validated against a table.
Date - Recall for Review	VORVDJ	Date	6	A date that represents when the customer credit status should be reviewed. Enter the recall for review date in a format that your database accepts. See the data item VODLC for examples.
Credit Manager	VOCMGR	Alpha	10	A code that represents the credit manager to whom workflow messages are sent. To receive workflow messages, an address book record for the credit manager must exist in the F0101 table, and the designation that you enter in this field must exist in UDC table 01/CR with the address book number assigned to the Description 2 field.
Collection Manager	VOCLMG	Alpha	10	A code that represents the collection manager to whom workflow messages are sent. To receive workflow messages, an address book record for the collection manager must exist in the F0101 table and the designation that you enter in this field must exist in UDC table 01/CR with the address book number assigned to the Description 2 field
Collection Report (Y/N)	VOCOLL	Alpha	1	A code that indicates whether the customer address book number is eligible to be printed on the Collection Report. If you leave this field blank, the system updates it with Y when the record is processed.
Apply Finance Charges (Y/N)	VOAFC	Alpha	1	A code that indicates whether the customer is eligible for delinquency fees. If you enter N in this field, the customer is bypassed during fee processing. If you leave this field blank, the system updates it with N when the record is processed.
Last Statement Date	VODT1J	Date	6	The date when the last statement was processed. The system displays this information from the A/R Statistical Summary table (F03B16S).
First Invoice Date	VODFIJ	Date	6	The date when the first invoice was entered into the system. Use a format that your database accepts. See the data item VODLC for examples. Alternatively, leave this field blank and run the Statistical History Refresh program (R03B16A) to update it.
Last Invoice Date	VODLIJ	Date	6	The date when the last invoice was entered into the system. Use a format that your database accepts. See the data item VODLC for examples. Alternatively, leave this field blank and run the Statistical History Refresh program.
Date Last Paid	VODLP	Date	6	The date of the last receipt. Use a format that your database accepts. See the data item VODLC for examples. Alternatively, leave this field blank and run the Statistical History Refresh program to update it.
Dun & Bradstreet Rating	VODB	Alpha	3	A value that represents the credit rating assigned by Dun & Bradstreet.
Dun & Bradstreet Date	VODNBJ	Date	6	The date that the Dun & Bradstreet ratings were available. Use a format that your database accepts. See the data item VODLC for examples.
TRW Rating	VOTRW	Alpha	3	A value that stores the credit rating assigned by TRW (Experian).
TRW Date	VOTWDJ	Date	6	The date that the TRW ratings were available. Use a format that your database accepts. See the data item VODLC for examples.
Amount Due	VOAD	Number	15	Reserved for future use.
Amount - Prior Year Finance Charge	VOAFCP	Number	15	The finance charges for the current and prior years. Use a format that your database accepts. Some databases accept a decimal identifier while others do not. If you use multicurrency, the amounts entered must be in the currency that corresponds to the Currency Code A/B Amounts field (VOCRCA) in the Customer Master Information program (P03013). Alternatively, leave these fields blank and run the Statistical History Refresh program to update them.
Amount - YTD Finance Charges	VOAFCY	Number	15	A number that indicates the finance charges for the current and prior years. Use a format that your database accepts. Some databases accept a decimal identifier while others do not. If you use multicurrency, the amounts entered must be in the currency that corresponds to Currency Code A/B Amounts field (VOCRCA) in the Customer Master Information program. Alternatively, leave these fields blank and run the Statistical History Refresh program to update them.
Amount Invoiced This Year	VOASTY	Number	15	A number that indicates the amount invoiced for the current and prior years. Use a format that your database accepts. Some databases accept a decimal identifier while others do not. If you use multicurrency, the amounts entered must be in the currency that corresponds to the Currency Code A/B Amounts field (VOCRCA) in the P03013 program. Alternatively, leave these fields blank and run the Statistical History Update program to update them.
Amount Invoiced	VOSPYE	Number	15	A number that indicates the amount invoiced for the current and prior years. Use a format that your database accepts. Some databases accept a decimal identifier while others do not. If you are using multicurrency, the amounts entered must be represented in the currency corresponding to the value entered in the Currency Code A/B Amounts field (VOCRCA). The system updates this field only when you run the Statistics Annual Close program (R03B161).
Amount Last Applied	VOALP	Number	15	A number that indicates the amount of the last payment received from this customer. Use a format that your database accepts. Some databases accept a decimal identifier while others do not. Alternatively, leave this field blank and run the Statistical History Refresh program to update it.
Person Opening Account	VOPOPN	Alpha	10	The User ID of the person opening the account. The system supplies the User ID.
Date - Account Opened	VODAOJ	Date	6	The date when the customer record was entered into the system. Use a format that your database accepts. See the data item VODLC for examples. If you leave this field blank, the system updates it with the date when the record was processed.
Policy Number (Internal)	VOPLY	Number	5	An internal code representing an Accounts Receivable delinquency policy. This field is updated when the policy name is entered on the Customer Master Information form. If you have established policies, you can update this field with the policy ID number (RFPLY) associated with the policy name stored in the A/R Delinquency Policy table (F03B25). A value that you enter in this field is validated against an entry in the table.
Deduction Manager	VOMAN8	Alpha	1	The address book number of the person who is responsible for deductions. The value that you enter in this field must exist in the F0101 table.
Auto Receipts Execution List	VOARL	Alpha	10	A value that you represents a list of algorithms used in auto receipt processing to match receipts to invoices in a specific order. The value that you enter in this field must exist in the Receipt Application Algorithm Execution Lists table (F03B50).
Address Book Category Codes 01 through 30	VOAC01 through VOAC30	Alpha	3	A code that is defined in the Address Book system and used in the Accounts Receivable system for reporting. The value that you enter in one of these fields must exist in the corresponding UDC table 01/01 - 01/30 (Address Book Category Codes). The values that you enter in the category codes for the Address Book Master (ABAC01 - ABAC30) are not updated in these fields.
Customer Status	VOCUSTS	Number	1	This field indicates the customer status for CRM purposes. Enter value 0 to set status as Active. Enter value 1 to set status as Inactive.