Dynamic Formatter Attributes (76B/F1)

You define layout attributes for electronic banking in the Dynamic Formatter Attributes UDC table (76B/F1). Attributes that begin with an S are constants. For example, S0002 is the attribute for zeros; and S0003 is the attribute for blanks. Attributes that begin with a Z are defined by each transaction application. For example, Z0002 is the company tax ID and Z0009 is the company name.

Some hard-coded attributes have a value in the Special Handling field. A value of 1 means that information originating in the JD Edwards EnterpriseOne system is cross-referenced to information that is provided by the bank. A value of 2 means that information originating with the bank is cross-referenced to information in the JD Edwards EnterpriseOne system.

This table describes the predefined attributes:

Value	Description	Description 2	Explanation
S0001	UDV - User Defined Value		A value that completes the places between two attributes with a character that you select. You define this value when you set up the layout details.
S0002	Blanks		A value that completes the places between two attributes with blanks.
S0003	Zeros		A value that completes the places between two attributes with zeros.
Z0001	Company Person/Corp Code	F0101 - TAXC	The value for the Person/Corporation Code field in the Address Book Master table (F0101) for the address book number that appears in the Company Constants table (F0010). 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 that is 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 that is 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 that is 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 that is 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 that is defined in the payment group and pulls the value before the separator (-) in the Bank Transit Number field in the F0030 table. For the Receipt process, the system parses information from the G/L bank account that is 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 that is 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 that is 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 that is defined in the payment group and uses the first three 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 that is defined in the payment group and uses the first three digits in the Bank Account Number field in the F0030 table and the value in the Description field from Bank Codes UDC (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.
Z0021	Bank Return Message	Bank
Z0022	Formatted File Line Count	UBE R76B047E Variable	This UBE counts the number of lines that are created inside the flat file.
Z0023	Payment Group Sequence	UBE R76B047E Variable	The sequence number from the A/P Payment Processing - Summary table (F04572), which is required to identify the payment in the return process in the client use code.
Z0024	Bank Return Code	Bank
Z0025	Payee Bank Number	F04572 - BNST	The first three digits from the Bank Transit Number field in the F04572 table.
Z0026	Payee Bank Agency No	F04572 - BNST	The numbers before the separator (/) from the Bank Transit Number field in the F04572 table.
Z0027	Payee Bank Account Number	F04572 - CBNK	The value for the Bank Account Number field in the A/P Payment Processing - Summary table (F04572).
Z0028	Payee Bank Agency Digit	F04572 - BNST	The value for the numbers before the separator in the Bank Transit Number field in the A/P Payment Processing - Summary table (F04572).
Z0029	Payee Bank Account Digit	F04572 - CBNK	The value from the Control Digit field in the F04572 table.
Z0030	Payee Bank Agency Number + Digit	F04572 - BNST	The values for the Z0026 and Z0028 attributes, separated by a dash (-).
Z0031	Payee Bank Account Number + Digit	F04572 - CBNK	The values for the Z0027 and Z0029 attributes, separated by a dash (-).
Z0032	Payee Name	F0101 - ALPH	The data for the attribute varies, depending on whether you are using the Payment or Receipt process: For the Payment process, the value for the Alpha Name field in the F0101 table for the address book number that appears in the Payee Number field in the F04572 table. For the Receipt process, the value for the Alpha Name field in the F0101 table for the address book number that appears in the Address Number field in the Customer Ledger table (F03B11).
Z0033	Document Number	None
Z0034	Payment Date	F04572 - DGJ	The data for the attribute varies, depending on whether you are using the payment or receipt process: For the payment process, the value for the G/L Date field in the F04572 table. For the receipt process, the value for the Payment Date field in the F04572 table.
Z0035	Payment Amount	F04572 - PAAP	The value for the Payment Amount field in the F04572 table.
Z0036	Bank Document Number	Bank
Z0037	Bank Return Payment Date	Bank
Z0038	Bank Return Payment Amount	Bank
Z0039	Bank Return Payment Document	Bank
Z0040	Form File Recs without Header	UBE R76B047E Variable
Z0041	Total Payment Amount	UBE R76B047E Variable	This UBE sums all of the payments in the file.
Z0042	Payee Person Corporation Code	F0101 - TAXC	The data for the attribute varies, depending on whether you are using the Payment or Receipt process: For the Payment process, the value for the Person Corporation Code field in the F0101 table for the address book number that appears in the Payee Address Number field in the F04572 table. You must create a bank cross-reference. For the Receipt process, the value for the Person Corporation Code field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table.
Z0043	Payee Tax ID	F0101 - TAX	The data for the attributes varies, depending on whether you are using the Payment or Receipt process: For the Payment process, the value from the Tax ID field in the F0101 table for the address book number that appears in the Payee Address Number field in the F04572 table. For the Receipt process, the value for the Tax ID field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table.
Z0044	Bar Code - Payee Bank Number	R76B0411 - BBRCD	Parses the Bank Code from the Bar Code field in the Voucher Additional Information - Brazil table (F76B04BC) for the first voucher found in the A/P Payment Processing - Detail table (F04573).
Z0045	Bar Code - Currency Code	R76B0411 - BBRCD	For the first voucher in the F04573 table, pulls the currency code from the Bar Code field in the F76B04BC table.
Z0046	Bar Code - Control Digit	R76B0411 - BBRCD	Parses the currency code from the Bar Code field in the F76B04BC table for the first voucher found in the F04573 table.
Z0047	Bar Code - Payment Amount	R76B0411 - BBRCD	Parses the payment amount from the Bar Code field in the F76B04BC table for the first voucher found in the F04573 table.
Z0048	Bar Code - Bar Code All	R76B0411 - BBRCD	The system identifies the first voucher in the F04573 table. It then locates that voucher in the F76B04BC table and writes the value from the Bar Code field to the layout.
Z0049	Due Date	F04572 - DGJ	The data for the attribute varies, depending on whether you are using the Payment or Receipt process: For the Payment process, the value from the G/L Date field in the F04572 table. For the Receipt process, the value from the Due Date field in the F03B11 table.
Z0050	Open Amount	F04572 - PAAP + ADSA	The sum of the values of the Payment Amount and Discount Amount fields in the F04572 table.
Z0051	Discount Taken	F04572 - ADSA	The data for the attribute varies, depending on whether you are using the Payment or Receipt process: For the Payment process, the value from the Discount Amount field in the F04572 table. For the Receipt process, the value from the Discount Amount field in the F03B11 table.
Z0052	Abatement Amount	Zero
Z0053	Discount + Rebate Amount	F04572 - ADSA	The value from the Discount Amount field in the F04572 table.
Z0054	Fee Amount	Zero	The fee amount that the system uses is determined by the processing options for the Process Return A/R Bank Tape Diskette - Dynamic Formatter process (R76B03ZR). Fee Invoice Creation processing option: Blank The amount is ignored. 1 The system creates an RF invoice with the amount of the fee paid. 2 The system creates an RF invoice with a calculated fee amount that is based on the daily late fee amount in the F76B03B1 table. 3 The system creates two RF invoices: one for the amount paid to the bank, and the other to the bank with fee amount difference PO Fee Process Order processing option: Blank The system performs a receipt first on original invoice, and then the difference on fee invoice. 1 The system performs receipt first on fee invoice, and then the difference on the original invoice.
Z0055	Rebate Amount	Zero
Z0056	Fee + Fee 2 Amount	Zero
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.
Z0059	Bank Agency Digit + Account Digit	F0030 - TNST + CNBK
Z0060	Company Bank Swift Code (Conv.)	F0030 - SWFT	The bank accord/agreement number for the bank that is defined in the Dynamic Formatter G/L Account File Numbers table (F76B477) for the BRPAGEL transaction type and the specified G/L bank account.
Z0061	Payee Address Book No	F04572 - AN8	For the Payment process, the value from the Payee Address Number field in the F04572 table. This information is required to identify the payment in return process in the client use code.
Z0062	Payment Sequence	UBE R76B047ES Variable	This UBE identifies the sequence of the number of payments for a payment group in the F04572 table.
Z0063	Line Sequence in Segment EP	UBE R76B047ES Variable	For each segment in a line sequence, this UBE resets the counter to zero.
Z0064	Bar Code - Free Field	R76B0411 - BBRCD	The value from the Bar Code field in the F76B04BC table for the first voucher found in the Accounts Payable Matching Document Detail table (F0414).
Z0065	File Formatter Line Type	UBE R76B047ER Variable
Z0066	Bar Code - Date Due Facto	F76B0411 - BBRCD
Z0067	Bank Duplicata Number	F7603B1 - BBDN	The value for the attribute varies, depending on the processing options: If the processing option is set to Bank (1), the value is 00000000000. If the processing option for Boleto Emitter is set to Company (2), the attribute value is determined like this: If a value exists in the Bank Duplicata Number field in the A/R Additional Information - Brazil table (F7603B1), the attribute value is the value in the field. If the Bank Duplicata Number field is blank, the attribute value is the Bank Duplicata next number for the BRCOBES transaction in the F76B477 table.
Z0068	Document Number	F7603B1- BBDN	The value in the Invoice Number field in the F03B11 table.
Z0069	Invoice Date	F03B11 - DIVJ	The value in the Invoice Date field in the F03B11 table.
Z0070	Client Use Code		The identifier sent during the outbound process and returned during the inbound process. The Client use code is a concatenation of the Document Company + Document Type + Document Number, Pay Item/suffix, and Address Number fields in the F03B11 table. This process is the first process to find an invoice. If this field is blank, the system uses the Bank Duplicata number.
Z0071	Bank Send Code	F7603B1 - BSCB	The value for the attribute varies, depending on the processing options for R76B03ZS: If the Bank processing option has a value, that value is used. If the Bank processing option does not have a value, 01 is used.
Z0072	Boleto Creation
Z0073	Protest Instructions Code		The value in the Protest Instructions Code field in the F7603B1 table.
Z0074	Protest Instructions		The value in the Protest Instructions Days field in the F7603B1 table.
Z0075	Amount Fee by Day		The value in the Daily Late Fee Amount field in the F7603B1 table.
Z0076	Due Date AR	F03B11 - DDJ	The value in the Discount Due Date field in the F03B11 table.
Z0077	Payee Address Line 1	F0116 - ADD1	The value for the attribute varies, depending on the processing options: If the Customer Address option is blank, uses the value for the Address 1 field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table. If the Customer Address option is set to 1, uses the value in the Send Invoice To field in the Customer Master by Line of Business table (F03012).
Z0078	Customer Postal Code	3 digit	The value for the attribute varies, depending on the processing options: If the Customer Address option is blank, uses the first five digits of the Postal Code field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table. If the Customer Address option is set to 1, uses the value in the Send Invoice To field in the F03012 table.
Z0079	Customer Postal Code	5 digit	The value for the attribute varies, depending on the processing options: If the Customer Address option is blank, uses the last three digits of the Postal Code field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table. If the Customer Address option is set to 1, uses the value in the Send Invoice To field in the F03012 table.
Z0080	Message Code		The value in the Message Code field in the F7603B1 table.
Z0081	Message Description		The value in the message code attachment for the Message Code field in the F7603B1 table.
Z0085	Discount Available by Day		The value in the Discount Available/30 field in the F03B11 table.
Z0086	Boleto Creation		The value in the Boleto Emitter option for the R76B03ZS processing options.
Z0087	Payment Group Control Number	F7603B1 - HDC	The value in the Carteira Number option for the R76B03ZS processing options.
Z0088	Payee City	F0116 - CYT1
Z0089	Payee State Code	F0116 - ADDS
Z0090	Payee Address Line 2	F0016 - ADD2	The value for the attribute varies, depending on the processing options: If the Customer Address option is blank, uses the value for the Address 2 field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table. If the Customer Address option is set to 1, uses the value in the Send Invoice To field in the F03012 table.
Z0091	Payee Address Line 3	F0016 - ADD3	The value for the attribute varies, depending on the processing options: If the Customer Address option is blank, uses the value for the Address 3 field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table. If the Customer Address option is set to 1, uses the value in the Send Invoice To field in the F03012 table.
Z0092	Payee Address Line 4	F0016 - ADD4	The value for the attribute varies, depending on the processing options: If the Customer Address option is blank, uses the value for the Address 4 field in the F0101 table for the address book number that appears in the Address Number field in the F03B11 table. If the Customer Address option is set to 1, uses the value in the Send Invoice To field in the F03012 table.
Z0093	Bank Return Code 2	Bank
Z0094	Bank Return Code 3	Bank
Z0095	Bank Return Code 4	Bank
Z0096	Bank Return Code 5	Bank
Z0097	Currency Code	F04572 - CRCD/F03B11 - CRCD
Z0098	Voucher Due Date	F04573 - DDJ
Z0100	Segment Code	**Bank**
Z0101	QR Code URL	QR Code URL	Contains payment recipient information.
Z0102	QR Code EMV	QR Code EMV	Payload of a QR Code.
Z0103	First PIX Key Type	First PIX Key Type	Payer PIX key type.
Z0104	First PIX Key	First PIX Key	Payer Account ID.
Z0105	Return QR Code URL	F7603B1 - RQRCU	QR Code URL returned from Company’s Bank.
Z0106	Return QR Code EMV	F7603B1 - RQRCE	QR Code EMV returned from Company’s Bank.
Z0107	Vendor PIX Key Type	F76B04BC - VPIXKT	Payee PIX Key type.
Z0108	Vendor PIX Key	F76B04BC - VPIXK	Payee Account ID.