AP_SDNCHUNK_AET

(SQL Table)
Index Back

AP Chunking State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 ALL_SETID_FLG Character(1) VARCHAR2(1) NOT NULL All Set IDs

Y/N Table Edit

Default Value: Y

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
8 SEQ_NBR_CRRNT Number(12,0) DECIMAL(12) NOT NULL Current Sequence Number
9 FROM_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Supplier ID
10 TO_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL New Supplier ID
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
13 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
14 AE_CHUNK_SIZE Number(6,0) INTEGER NOT NULL Chunk
15 ORDER_BY_AP Character(50) VARCHAR2(50) NOT NULL Order By AP
16 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status

Default Value: 0