FILENAME: D9530F34 MASTER
DESCRIPTION: FRSV3.0 PURCHASE ORDER FOCUS FILE
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
POA02 DOCUMENT_TYPE
A1
DOCUMENT TYPE
POA04 PO_NUM
A7
PO NUM
I
POA88 FISCAL_YR
A2
FISCAL YR
POA90 CAMPUS_CODE A2 CAMPUS CODE
FRSACCT   A06 SECURITY ACCOUNT
POA92 DIVISION_DOC
A2
DIVISION DOC
POA94 SCHOOL
A2
SCHOOL
FRSDEPT  
A7
SECURITY DEPT
POA96 DEPARTMENT
A5
DEPARTMENT
POC49 SUB_DEPARTMENT
A2
SUB DEPARTMENT
POC50 EXECUTIVE_LEVEL
A2
EXECUTIVE LEVEL
POC51 FUND_GROUP
A2
FUND GROUP
POC52 PO_PURPOSE_CODE
A2
PURPOSE CODE
POC53 SECURITY_CODE
A6
SECURITY CODE
POE10 LINE_NUM
A3
LINE NUM
POE19 DELETE_FLAG A1 DELETE FLAG
POE20 FREEZE_FLAG A1 FREEZE FLAG
POE21 IN_PROCESS_FLAG A1 PROCESS FLAG
POE22 DISC_FLAG A1 DISC FLAG
POE23 NOTES_FLAG A1 NOTES FLAG
POE26 AUDIT_DT YYMD DATE MISSING=ON AUDIT DT
POE28 AUDIT_TIME A6 AUDIT TIME
POE32 TEXT_CODE_1 A3 TEXT CODE 1
POE34 TEXT_CODE_2 A3 TEXT CODE 2
POE36 TEXT_CODE_3 A3 TEXT CODE 3
POE38 TEXT_CODE_4 A3 TEXT CODE 4
POE40 TEXT_CODE_5 A3 TEXT CODE 5
POE42 TEXT_CODE_6 A3 TEXT CODE 6
POE44 TEXT_CODE_7 A3 TEXT CODE 7
POE46 TEXT_CODE_8 A3 TEXT CODE 8
POE48 TEXT_CODE_9 A3 TEXT CODE 9
POE50 TEXT_CODE_10 A3 TEXT CODE 10
POE52 TEXT_CODE_11 A3 TEXT CODE 11
POE54 TEXT_CODE_12 A3 TEXT CODE 12
POE60 TEXT_1 A40 TEXT 1
POE62 TEXT_2 A40 TEXT 2
POE64 TEXT_3 A40 TEXT 3
POE66 TEXT_4 A40 TEXT 4
POE68 TEXT_5 A40 TEXT 5
POE70 TEXT_6 A40 TEXT 6
POE80 BATCH_REF A6 BATCH REF
POE82 BATCH_DT YYMD DATE MISSING=ON BATCH DT
POA19 DELETE_FLAG A1 DELETE FLAG
POA20 FREEZE_FLAG A1 FREEZE FLAG
POA21 IN_PROCESS_FLAG A1 IN PROCESS FLAG
POA22 DISC_FLAG A1 DISC FLAG
POA23 NOTES_FLAG A1 NOTES FLAG
POA30 AUDIT_DT YYMD DATE MISSING=ON AUDIT DT
POA32 AUDIT_TIME A6 AUDIT TIME
POA34 VENDOR_NUM A11 VENDOR NUM
VN_DGT1 A1 VENDOR DIGIT
VN_DGT2_11 A10 VENDOR DIGITS 2-11
VN_DGT2_10 A9 VENDOR DIGITS 2-10
VN_DGT_11   A1 VENDOR DIGIT 11
POA36 PO_TYPE A2 PO TYPE
POA38 CURRENCY_CODE A3 CURRENCY CODE
POA40 PO_DT YYMD DATE MISSING=ON PO DT
POA42 START_DT YYMD DATE MISSING=ON START DT
POA44 END_DT YYMD DATE MISSING=ON END DT
POA46 PAID_AMT D12.2M PAID AMT
POA48 TOTAL_AMT D12.2M TOTAL AMT
POA49 TOTAL_WITH_TAX D12.2M TOTAL WITH TAX
POA50 PRINT_CODE A1 PRINT CODE
POA52 DT_LAST_PRINTED YYMD DATE MISSING=ON DT LAST PRINTED
POA60 DISC_DUE_DAYS I6 I2 DISC DUE DAYS
POA62 DISC_PERCENT D6.3M DISC PERCENT
POA64 TERMS_IND A1 TERMS IND
POA66 NET_PAY_DAYS I6 I2 NET PAY DAYS
POA68 FREIGHT_TERMS A2 FREIGHT TERMS
POA69 ROUTE_CODE A2 ROUTE CODE
POA70 EXPECTED_DELIVERY YYMD DATE MISSING=ON EXPECTED DELIVERY
POA72 BUYER_CODE A3 BUYER CODE
POA74 BUYER_PHONE A3 BUYER PHONE
POA78 QUOTE_DT YYMD DATE MISSING=ON QUOTE DT
POA80 QUOTE_REF A20 QUOTE REF
POA82 CHANGE_ORDER_DT YYMD DATE MISSING=ON CHANGE ORDER DT
POA84 CHANGE_ORDER_NUM A2 CHANGE ORDER NUM
POA85 TRACKING_STATUS A1 TRACKING STATUS
POA86 DOCUMENT_REF A7 DOCUMENT REF
POB00 AUTHORIZATION_ID_1 A9 AUTHORIZATION ID 1
POB02 AUTHORIZATION_ID_2 A9 AUTHORIZATION ID 2
POB04 DEPARTMENT_CONTACT A30 DEPARTMENT CONTACT
POB06 SHIP_TO_NAME A30 SHIP TO NAME
POB08 SHIP_TO_ADDRESS_1 A30 SHIP TO ADDRESS 1
POB12 SHIP_TO_ADDRESS_2 A30 SHIP TO ADDRESS 2
POB14 SHIP_TO_ADDRESS_3 A30 SHIP TO ADDRESS 3
POB16 SHIP_TO_ADDRESS_4 A30 SHIP TO ADDRESS 4
POB18 SHIP_TO_CITY A20 SHIP TO CITY
POB20 SHIP_TO_STATE A2 SHIP TO STATE
POB22 SHIP_TO_COUNTRY A3 SHIP TO COUNTRY
POB24 SHIP_TO_ZIP A12 SHIP TO ZIP
ZIP_5_SHP A5
ZIP_4_SHP A4
ZIP_3_SHP A3
SHIP_TO_PHONE SHIP_TO_PHONE A15 SHIP TO PHONE
AREA_CD_SHP A3
PHONE_7_SHP A7
PHON_3_SHP A3
PHON_4_SHP A4
PHON_EXT_SHP A5
POB80 FED_START_DT YYMD DATE MISSING=ON FED START DT
POB82 FED_END_DT YYMD DATE MISSING=ON FED END DT
POB64 FED_CURRENCY_CODE A3 FED CURRENCY CODE
POB66 FED_FLAG A1 FED FLAG
POB96 SOURCE_CODE_CREATE A1 SOURCE CODE CREATE
POB97 CREATE_DT YYMD DATE MISSING=ON CREATE DT
POB99 CREATE_TIME A6 CREATE TIME
POC00 FIRST_PO_PRINT A1 FIRST PO PRINT
POC02 ORG_UNIT A1 ORG UNIT
POC10 THREE_WAY_MATCH A1 THREE WAY MATCH
POC12 PURPOSE_CODE A2 PURPOSE CODE
POC20 APRVL_SWITCH A1 APRVL SWITCH
POC38 PR_TRANSFER_CODE A1 PR TRANSFER CODE
POC40 SOURCE_OF_FUNDING1 A2 SOURCE OF FUNDING1
POC41 SOURCE_OF_FUNDING2 A2 SOURCE OF FUNDING2
POC42 SOURCE_OF_FUNDING3 A2 SOURCE OF FUNDIGN3
POC43 SOURCE_OF_FUNDING4 A2 SOURCE OF FUNDING4
POC44 SOURCE_OF_FUNDING5 A2 SOURCE OF FUNDING5
POC45 SOURCE_OF_FUNDING6 A2 SOURCE OF FUNDING6
POC46 SOURCE_OF_FUNDING7 A2 SOURCE OF FUNDING7
POC47 SOURCE_OF_FUNDING8 A2 SOURCE OF FUNDING8
POC48 LAST_ASSET_SEQ_NUM I6 I2 LAST ASSET SEQ NUM
POC55 INVOICE_AMT_W_TAX D12.2M INVOICE AMT W TAX
POD3X UC_CONT_BEG_DATE YYMD DATE MISSING=ON UC CONT BEG DATE
POD3Y UC_CONT_END_DATE YYMD DATE MISSING=ON UC CONT END DATE
POD3Z UC_OBL_AMT D12.2M UC OBL AMT
POD5B UC_CONT_AWD_NUM A15 UC CONT AWD NUM
POD5C UC_SOLE_SOURCE_CD A2 UC SOLE SOURCE CD
POD5D UC_SET_ASIDE_EMPT A1 UC SET ASIDE EMPT
POD5E UC_PRODUCT_CATEGOR A11 UC PRODUCT CATEGOR
POC57 BATCH_REF A6 BATCH REF
POC58 BATCH_DT YYMD DATE MISSING=ON BATCH DT
POC63 BATCH_DOCUMENT_NUM A7 BATCH DOCUMENT NUM
POC70 EDI_FLAG A1 EDI FLAG
POC72 EDI_INV_METHOD A3 EDI INV METHOD
POC74 EDI_LST_EXTRACT_DT YYMD DATE EDI LST EXTRACT DT
POC78 EDI_EXTRACT_CODE A1 EDI EXTRACT CODE
POC80 EDI_EXTRACTED A1 EDI EXTRACTED
PO_FISCAL_YR A2 PO FISCAL YR
PO_CAMPUS_CD A2 PO CAMPUS CD
PO_ACCT A6 PO ACCOUNT
PO_SUBCODE A4 PO ACCOUNT SUBCODE
PO_ACCT_PCT POB4D D6.2 PO ACCOUNT PERCENT
PO_ACCT_AMT POB4E D12.2M PO ACCOUNT AMOUNT
PO_ACT_AT_VO POB4F D12.2M PO ACCOUNT AMOUNT VOUCHERED
FED_FISCAL_YR A2 FED FISCAL YR
FED_CAMPUS_CD   A2 FED CAMPUS CD
FED_ACCT POB7C A10 FED ACCOUNT
FED_FACCT A06 FED ACCOUNT
FED_SUB A04 FED SUBCODE
FED_AMT POB7D D12.2M FED AMOUNT

 

508 UsableNet Approved (v. 1.2.1)