Optional Fields Used by the Accounts Payable System
This table lists fields in the F0401Z1 table that are optional and are used by the Accounts Payable 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 Supplier Master MBF (P0400047), if set up. This field is required if you use outbound processing. |
Direction Indicator |
VODRIN |
Alpha |
1 |
A value that specifies whether the transaction is inbound or outbound. Values are: Blank: Inbound 2: Outbound |
EDI - Detail Lines Processed |
VOEDDL |
Number |
5 |
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 |
VOAPC |
Alpha |
4 |
A value that, in conjunction with the company number, determines the accounts payable trade (offset) account to which the transaction will post. The account established in the AAI item PCxxxx (where xxxx= the value in the G/L Offset field) will be used in the post process. The AAI can be established for each company or for the default company 00000. The value in this field becomes the default for all vouchers entered for the supplier. Do not complete this field unless you want to direct transactions to offset accounts other than those specified in the AAI item PC. |
Business Unit - A/P Default |
VOMCUP |
Alpha |
12 |
A value that, in conjunction with the VOOBAP and VOAIDP fields, specifies a default expense account that is automatically supplied on the G/L Distribution form when you enter a voucher. Do not specify a default expense account if you complete the fields for a model journal entry (VOCKOP, VODCAP, VODTAP). The model journal entry overrides the default expense account. |
Object - A/P Default |
VOOBAP |
Alpha |
6 |
A value that, in conjunction with the VOMCUP and VOAIDP fields, specifies a default expense account that is automatically supplied on the G/L Distribution form when you enter a voucher. Do not specify a default expense account if you complete the fields for a model journal entry (VOCKOP, VODCAP, VODTAP). The model journal entry overrides the default expense account. |
Subsidiary - A/P Default |
VOAIDP |
Alpha |
8 |
A value that, in conjunction with the VOMCUP and VOOBAP fields, specifies a default expense account that is automatically supplied on the G/L Distribution form when you enter a voucher. Do not specify a default expense account if you complete the fields for a model journal entry (VOCKOP, VODCAP, VODTAP). The model journal entry overrides the default expense account. |
Document Company - A/P Model |
VOKCOP |
Alpha |
5 |
A value that, in conjunction with the VODCAP and VODTAP fields, specifies a model journal entry in the Account Ledger table (F0911). The values are not validated. If you enter a valid model journal entry, the account you specified is used in the G/L Distribution form when you enter a voucher. Do not specify a model journal entry if you complete the fields for a default expense account (VOMCUP, VOOBAP, VOAIDP). The model journal entry overrides the default expense account. |
Document Number - A/P Model |
VODCAP |
Number |
8 |
A value that, in conjunction with the VOKCOP and VODTAP fields, specifies a model journal entry in the F0911 table. If you enter a valid model journal entry, the account specified is used in the G/L Distribution form when you enter a voucher. Do not specify a model journal entry if you complete the fields for a default expense account (VOMCUP, VOOBAP, VOAIDP). The model journal entry overrides the default expense account. |
Document Type - A/P Model |
VODTAP |
Alpha |
2 |
A value that, in conjunction with the VOKCOP and VODCAP fields, specifies a model journal entry in F0911 table. The values that you enter are not validated. If you enter a valid model journal entry, the account specified is used in the G/L Distribution form when you enter a voucher. Do not specify a model journal entry if you complete the fields for a default expense account (VOMCUP, VOOBAP, VOAIDP). The model journal entry overrides the default expense account. |
Currency Code |
VOCRRP |
Alpha |
3 |
This field is displayed only if multicurrency is activated. A code that represents the currency to be used when a voucher is entered for this supplier. The value that you enter in this field must exist in the Currency Codes table (F0013). If you leave this field blank, the system uses the currency associated with the company entered on the voucher. |
Tax Rate Area |
VOTXA3 |
Alpha |
10 |
A code that identifies the taxing authority to use on vouchers for this supplier. The value that you enter in this field must exist in the Tax Areas table (F4008). |
Tax Explanation Code |
VOEXR2 |
Alpha |
2 |
A code that identifies the type of tax to apply to vouchers for this supplier. The value that you enter in this field must exist in UDC table 00/EX (Tax Explanation Codes). |
Hold Payment Code |
VOHDPY |
Alpha |
1 |
A code that specifies whether you can enter vouchers and payments for this supplier. Values are: 1 or Y: Hold payment of outstanding vouchers and prevent entry of new vouchers. 2: Hold payment of outstanding vouchers but allow entry of new vouchers. N: Allow entry of vouchers and payments. If you leave this field blank, the system uses N. |
Tax Rate Area - Withholding |
VOTXA2 |
Alpha |
10 |
A value that identifies the taxing authority to use for withholding tax for a supplier. The value in this field is written to the Supplier Master table (F0401). This field is not displayed in the Accounts Payable system. |
Tax Explanation Code - Withholding |
VOEXR3 |
Alpha |
2 |
A value representing the type of withholding tax to be used for a supplier. Any value that you enter in this field is written to the F0401 table. This field is not displayed in the Accounts Payable system. |
Tax Authority |
VOTAWH |
Number |
8 |
A number that specifies the tax authority to whom withholding taxes must be paid for the supplier. The value that you enter in this field must exist in the F0101 table. |
Withholding Percent |
VOPCWH |
Number |
5 |
A number that specifies the rate of withholding tax to be retained from payment to a supplier. The number is expressed as a decimal. For example, 20 percent would be expressed as.20. |
Payment Terms |
VOTRAP |
Alpha |
3 |
A code that specifies the due date and amount of discount available to a supplier. The value in this field is entered on all vouchers for this supplier. The value that you enter in this field must exist in the Payment Terms table (F0014). |
Multiple Payments |
VOSCK |
Alpha |
1 |
A code that indicates whether a separate check will be issued for each pay item on a voucher. Values are: Y: Create a separate check for each voucher pay item. N: Create one check for the voucher, regardless of the number of pay items. C: Create one check per contract and collate the checks in contract or job number order. If you leave this field blank, the system uses a value of N. |
Payment Instrument |
VOPYIN |
Alpha |
1 |
A code that specifies the format of a payment to be made to a supplier. The value in this field must exist in UDC table 00/PY (Payment Instrument). |
Approver Number |
VOSNTO |
Number |
8 |
A number that identifies the person responsible for approving vouchers that are logged using Voucher Logging. The value in this field must exist in the F0101 table. |
Pre-Note Code |
VOAB1 |
Alpha |
1 |
A code that indicates whether a supplier is in setup status for electronic funds transfer (EFT) processing. Values are: P: Pre-note status. The system writes a check to the supplier as well as makes an entry to the bank tape table for verification. he system does not do an electronic transfer of funds in this status. N: The bank has received and verified the supplier's account information. The system will process future payments to this supplier using EFT. If the field is blank, the system assigns the value P when it processes the first payment. |
Float Days for Payments |
VOFLD |
Number |
3 |
A number that indicates the number of days to be added to the payment date for payments. This number updates the Cleared/Value Date (RMVLDT) in the Accounts Payable Matching Document Detail table (F0414) when automatic payments are run. |
Amount Vouchered YTD |
VOAYPD |
Number |
15 |
A value indicating the number of accounts payable vouchers written during the current year. Some databases accept a decimal identifier while others do not. If you use multicurrency, the amount should be in the currency you entered in the VOCRCA field. Run the Update YTD Voucher Amount program (R04820A) to update this field. |
Amount Vouchered PYE |
VOAPPD |
Number |
15 |
A value indicating the amount of vouchers entered in the prior year. The system updates this value when you run the Update YTD Voucher Amount program. |
Carrier Number |
VOCARS |
Number |
8 |
A value that represents the address book number of the carrier specified by the customer or your organization. Use this field for route and special handling requirements. The value in this field must exist in the F0101 table. |