APRPTBLINC

REFERENCED BY
AP145 AP146 AP245


UPDATED BY
AP115 AP144 AP170 AP190 AP45.3 CB300
CB56.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RIC-SOURCE
Element: Acct Type		Alpha 3
AP170 AP45.3
CB56.2
RIC-YEAR-PAID
Element: Year		Numeric 4
AP170 AP45.3
CB56.2
RIC-RIC-OBJ-ID
Element: Obj Id		Numeric 12
AP170 AP45.3
CB56.2
RIC-INCOME-CODE
Element: Income Code		Alpha 4
AP170 AP45.3
CB56.2
RIC-TAX-ID
Element: Tax Id		Alpha 20
AP170 AP45.3
CB56.2
RIC-PAYMENT-DATE
Element: Date		Numeric 8 (yyyymmdd)
AP170 AP45.3
CB56.2
RIC-PAID-AMT
Element: Intl Amt		Signed 18.2
AP170 AP45.3
CB56.2
RIC-REPORTABLE-AMT
Element: Intl Amt		Signed 18.2
AP170 AP45.3
CB56.2
RIC-TRAN-CURRENCY
Element: Currency Code		Alpha 5
AP170 AP45.3
CB56.2
RIC-TRANS-NBR
Element: Trans Nbr		Alpha 10 (Right Justified)
AP170 AP45.3
CB56.2
RIC-COMPANY
Element: Company		Numeric 4
AP170 AP45.3
CB56.2
RIC-PROC-LEVEL
Element: Process Level		Alpha 5
AP170 AP45.3
CB56.2
RIC-VENDOR-GROUP
Element: Vendor Group		Alpha 4
AP170 AP45.3
CB56.2
RIC-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
AP115 AP45.3
RIC-PAYEE-NAME
Element: Legal Name		Alpha 80 (Lower Case)
AP170 AP45.3
CB56.2
RIC-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
AP170 AP45.3
CB56.2
RIC-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
AP170 AP45.3
CB56.2
RIC-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
AP170 AP45.3
CB56.2
RIC-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
AP170 AP45.3
CB56.2
RIC-CITY-ADDR5
Element: City		Alpha 18 (Lower Case)
AP170 AP45.3
CB56.2
RIC-STATE-PROV
Element: State Prov		Alpha 2
AP170 AP45.3
CB56.2
RIC-POSTAL-CODE
Element: Postal Code		Alpha 10 (Lower Case)
AP170 AP45.3
CB56.2
RIC-CASH-CODE
Element: Cash Code		Alpha 4
AP170 CB56.2
RIC-BANK-INST-CODE
Element: Bank Inst Code		Alpha 3
AP170 CB56.2
RIC-TRANS-IDENT
Element: Trans Ident		Numeric 10
AP170 CB56.2
RIC-TIN-TYPE
Element: Flag Num		Numeric 1
AP170 AP45.3
CB56.2


APRPTBLINC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RICSET1 SOURCE
YEAR-PAID
RIC-OBJ-ID
AP115 AP145
AP146 AP190
AP45.3 CB300
CB56.2
RICSET2 COMPANY
PAYMENT-DATE
PROC-LEVEL
VENDOR
PAYEE-NAME
TAX-ID
SOURCE
YEAR-PAID
RIC-OBJ-ID
KeyChange
AP145 AP146
AP245 AP45.3
RICSET3 VENDOR-GROUP
VENDOR
PAYMENT-DATE
PAYEE-NAME
SOURCE
YEAR-PAID
RIC-OBJ-ID
KeyChange
AP115 AP144
RICSET4 TAX-ID
PAYMENT-DATE
SOURCE
YEAR-PAID
RIC-OBJ-ID
KeyChange
AP45.3
RICSET5 PAYMENT-DATE
SOURCE
YEAR-PAID
PAYEE-NAME
RIC-OBJ-ID
KeyChange
AP45.3


APRPTBLINC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbpayment CBPAYMENT Required
RIC-CASH-CODE->CBM-CASH-CODE
RIC-BANK-INST-CODE->CBM-BANK-INST-CODE
RIC-TRANS-IDENT->CBM-TRANS-IDENT

File created: Thu Jun 09 11:07:40 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.