FILENAME: D9530F32 MASTER
DESCRIPTION: FRSV3.0 PURCHASE INVOICE SHADOW FILE
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
PI002_PIRT DOCUMENT_TYPE
A1
DOCUMENT TYPE
PI004_PIRT PO_NUM
A7
PO NUM
I
PI008_PIRT INVOICE_NUM
A14
INVOICE NUM
FRSACCT   A6 SECURITY ACCOUNT
POA94 SCHOOL A2 SECURITY UNIT
POA92 DIVISION_DOC
A2
SECURITY CAMPUS
FRSDEPT  
A7
SECURITY DEPT
PAO96 DEPARTMENT
A5
SECURITY DEPT
POC49 SUB_DEPARTMENT
A2
SECURITY SUBDEPT
POC50 EXECUTIVE_LEVEL
A2
SECURITY EXECLVL
POC51 FUND_GROUP
A2
SECURITY FUNDGRP
POC52 PO_PURPOSE_CODE
A2
SECURITY FUNCTION
POC53 SECURITY_CODE
A6
SECURITY SECURECD
PI019 DELETE_FLAG
A1
DELETE FLAG
PI020 FREEZE_FLAG
A1
FREEZE FLAG
PI021 IN_PROCESS_FLAG
A1
IN PROCESS FLAG
PI022 DISC_FLAG
A1
DISC FLAG
PI028 AUDIT_DT YYMD DATE AUDIT DT
PI030 AUDIT_TIME A6 AUDIT TIME
PI032 VOUCHER_TRANSFER A1 VOUCHER TRANSFER
PI034 VENDOR_NUM A11 VENDOR NUM
PI036 INVOICE_DT YYMD DATE INVOICE DT
PI038 DUE_DT YYMD DATE DUE DT
PI040 GROSS_AMT D12.2M GROSS AMT
PI042 CURRENCY_CODE A3 CURRENCY CODE
PI044 HOLD_CODE A1 HOLD CODE
PI046 ENCLOSURE_CODE A1 ENCLOSURE CODE
PI048 CREDIT_MEMO_FLAG A1 CREDIT MEMO FLAG
PI050 ORIG_INVOICE_NUM A14 ORIG INVOICE NUM
PI052 VOUCHER_NUM A7 VOUCHER NUM
PI062 BANK_NUM A2 BANK NUM
PI064 CHECK_NUM A6 CHECK NUM
PI066 PAYMENT_OPTIONS A1 PAYMENT OPTIONS
PI068 VOUCHER_DESC A15 VOUCHER DESC
PI070 CREATE_DT YYMD DATE CREATE DT
PI072 CREATE_TIME I9 CREATE TIME
PI074 BATCH_REF A6 BATCH REF
PI076 BATCH_DT YYMD DATE BATCH DT
PI120 DISC_DUE_DAYS I6 DISC DUE DAYS
PI121 DISC_PERCENT D6.3 DISC PERCENT
PI122 TERMS_IND A1 TERMS IND
PI123 NET_DUE_DAYS I6 NET DUE DAYS
PI130 FX_FEED_FLAG A1 FX FEED FLAG
PI132 LAST_ASSET_SEQ_NUM I6 LAST ASSET SEQ NUM
PI134 INVOICE_FISCAL_YR A2 INVOICE FISCAL YR
PI136 CODE_1099 A1 CODE 1099
PI16A UC_RCPT_DT_2WAY_MA YYMD DATE RECEIPT DATE 2 WAY MATCH
PI16C UC_OPERATOR_NUMBER A4 UC OPERATOR NUMBER
PI078 FISCAL_YR_1 A2 FISCAL YEAR1
PI079 CAMPUS_CODE_1 A2 CAMPUS CODE 1
PI_AO_ACCT PI080 A10 INVOICE ACCOUNT OVERRIDE ACCOUNT
ACCOUNT_NUM PI080A A06 INVOICE ACCOUNT OVERRIDE ACCOUNT
SUBCODE PI080B A04 INVOICE ACCOUNT OVERRIDE SUBCODE
PI081 PERCENT_1 D6.2 PERCENT 1
PI082 AMT_1 D12.2M AMT 1
PI214_PIDT LINE_NUM I6 LINE NUM
PI250 FISCAL_YR A2 FISCAL YR
PI251 CAMPUS_CODE A2 CAMPUS CODE
FRSACCOUNT PI252 A10 FRS ACCOUNT
ACCOUNT_NUML ACCOUNT_NUM A6 ACCOUNT NUM
SUBCODEL SUBCODE A4 SUBCODE
LFS052 A2 CAMPUS
LFS050 A2 UNIT
FRSDEPTL A7
LFS054 A5 DEPARTMENT
LFA056 A2 SUB DEPARTMENT
LFS048 A2 EXECUTIVE LEVEL
LFS066 A2 FUND GROUP
LFS074 A2 ACCOUNT FUNCTION
LFS088 A6 SECURITY CODE
PI219 DELETE_FLAG A1 DELETE FLAG
PI220 FREEZE_FLAG A1 FREEZE FLAG
PI221 IN_PROCESS_FLAG A1 IN PROCESS FLAG
PI222 DISC_FLAG A1 DISC FLAG
PI228 AUDIT_DT YYMD DATE AUDIT DT
PI230 AUDIT_TIME A6 AUDIT TIME
PI233 QUANTITY D10.2 QUANTITY
PI234 UNIT_PRICE D14.4 UNIT PRICE
PI236 UNIT_OF_MEASURE A3 UNIT OF MEASURE
PI238 EXTENDED_PRICE D12.2M EXTENDED PRICE
PI239 EXT_PRICE_WITH_TAX D12.2M EXT PRICE WITH TAX
PI240 TAX_CODE A2 TAX CODE
PI241 TAX_PERCENT D8.4M TAX PERCENT
PI242 INVOICE_STATUS A1 INVOICE STATUS
PI246 CODE_1099 A1 CODE 1099
ERROR_CODE_A ERROR_CODE_A A1 ERROR CODE A
ERROR_CODE_B ERROR_CODE_B A1 ERROR CODE B
ERROR_CODE_C ERROR_CODE_C A1 ERROR CODE C
ERROR_CODE_D ERROR_CODE_D A1 ERROR CODE D
ERROR_CODE_E ERROR_CODE_E A1 ERROR CODE E
ERROR_CODE_X ERROR_CODE_X A1 ERROR CODE X
ERROR_CODE_I ERROR_CODE_I A1 ERROR CODE I
ERROR_CODE_T ERROR_CODE_T A1 ERROR CODE T
ERROR_CODE_W ERROR_CODE_W A1 ERROR CODE W
PI254 LINE_ITEM_DESC_1 A40 LINE ITEM DESC 1
PI256 LINE_ITEM_DESC_2 A40 LINE ITEM DESC 2
PI258 PBD085_SW A1 PBD085 SW
PI260 UOM_ERROR A1 UOM ERROR

 

508 UsableNet Approved (v. 1.2.1)