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:
|
Z0004 |
Company Bank Account Number |
F0030 - CBNK |
The data for the attribute varies, depending on whether you are using the Payment or Receipt process:
|
Z0005 |
Company Bank Agency Digit |
F0030 - TNST |
The data for the attribute varies, depending on whether you are using the Payment or Receipt process:
|
Z0006 |
Company Bank Account Digit |
F0030 - CHKD |
The data for the attribute varies, depending on whether you are using the Payment or Receipt process:
|
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 |