Automatic Payment Process, Inbound, Line Type 1 (File Header)

This table shows examples of the attributes that you might use for inbound transactions with line type 1 (file header):

Value

Description

Description 2

Explanation

Z0001

Company Person/Corp Code

F0101 - TAXC

The value for the Person/Corporation Code field in the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in the company constants, the system uses the Parent Address Number Person/Corporation Code.

Z0002

Company Tax ID

F0101 - TAX

The value for the Tax ID field in the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in the company constants, the system uses the Parent Address Number Tax ID.

Z0003

Company Bank Agency

F0030 - TNST

The data for the attribute varies, depending on whether you are using the Payment or Receipt process:

  • For the Payment process, the system parses information from the G/L bank account defined in the payment group and pulls the value before the separator (/) in the Bank Transit Number field in the Bank Transit Master table (F0030).

  • For the Receipt process, the system parses information from the G/L bank account defined in the processing options and pulls the value before the separator (/) in the Bank Transit Number field in the F0030 table.

Z0004

Company Bank Account Number

F0030 - CBNK

The data for the attribute varies, depending on whether you are using the Payment or Receipt process:

  • For the Payment process, the system parses information from the G/L bank account defined in the payment group and pulls the value in the Bank Account Number field in the F0030 table.

  • For the Receipt process, the system parses information from the G/L bank account defined in the processing options and pulls the value in the Bank Account Number field in the F0030 table.

Z0005

Company Bank Agency Digit

F0030 - TNST

The data for the attribute varies, depending on whether you are using the Payment or Receipt process:

  • For the Payment process, the system parses information from the G/L bank account defined in the payment group and pulls the value before the separator (-) in the Bank Transit Number field in the Bank Transit Master table (F0030).

  • For the Receipt process, the system parses information from the G/L bank account defined in the processing options and pulls the value before the separator (-) in the Bank Transit Number field in the F0030 table.

Z0006

Company Bank Account Digit

F0030 - CHKD

The data for the attribute varies, depending on whether you are using the Payment or Receipt process:

  • For the Payment process, the system parses information from the G/L bank account defined in the payment group and pulls the value in the Control Digit field in the F0030 table.

  • For the Receipt process, the system parses information from the G/L bank account defined in the processing options and pulls the value in the Control Digit field in the F0030 table.

Z0007

Company Bank Agency Number + Digit

F0030 - TNST

The values for attributes Z0003 and Z0005; they are separated by a dash (-).

Z0008

Company Bank Account Number + Digit

F0030 - CBNK + CHKD

The values for attributes Z0004 and Z0006; they are separated by a dash (-).

Z0009

Company Name

F0101 - ALPH

The address book number in the F0010 table. If PO Unique Payment is activated in the company constants, the system uses the Parent Address Number Alpha Name.

Z0010

Formatted File Date Created

UBE B9800100 - Get Audit Info

The date from the Get Audit Information field in the UBE.

Z0011

Formatted File Time Created

UBE B9800100 - Get Audit Info

The Time from the Get Audit Information field in the UBE.

Z0012

Company Bank Number

F0030 - TNST

The system parses information from the G/L bank account defined in the payment group and uses the first 3 digits in the Bank Number field in the F0030 table.

Z0013

Company Bank Name

F0030 - DL01

The system parses information from the G/L bank account defined in the payment group and uses the first 3 digits in the Bank Account Number field in the F0030 table and the value in the Description field from the Bank Codes UDC table (76/BC).

Z0014

Payment Instrument

F0411 - PYIN

Z0015

Company Street Name

F0101 - ADD1

The value for the Address 1 field in the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in company constants, the system uses the Parent Address Number Address 1.

Z0016

Company Street Number

NONE

Z0017

Company Street Complement

NONE

Z0018

Company City

F0101 - CTY1

The value for the City field in the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in company constants, the system uses the Parent Address Number City.

Z0019

Company Postal Code - No Mask

F0101 - ADDZ

The value for the Postal Code field in the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in company constants, the system uses the Parent Address Number Postal Code.

The system uses the value in the Postal Code field without the separator (-).

Z0020

Company State Code

F0101 - ADDS

The value for the State field in the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in company constants, the system uses the Parent Address Number State.

Z0022

Formatted File Line Count

UBE R76B047E Variable

This UBE counts the number of lines created inside the flat file.

Z0057

Company Postal Code with Mask

F0101 - ADDZ

The value for the Postal Code field from the F0101 table for the address book number that appears in the F0010 table. If PO Unique Payment is activated in company constants, the system uses the Parent Address Number Postal Code. The attribute uses the value in the Postal Code field with the separator (-).

Z0058

Payment Group Next Number

UBE R76B047ES NN 04/06

This UBE generates a unique identifier for the flat file and assigns a next number from 04/06 for each file.

Z0060

Company Bank Swift Code (Conv.)

F0030 - SWFT

The bank accord/agreement number for the bank as defined in the Dynamic Formatter G/L Bank Account File Numbers table (F76B477) for the BRPAGEL transaction type and the specified G/L bank account.

Z0065

File Formatter Line Type

UBE R76B047ER Variable