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.