PROCESS_INSTANCEN=No
P=Processed
Y=Yes
C=Journal Code
D=Document Type
A=Automatic Numbering
M=Manually Entered
EM_PAY_XTRN_AET(SQL Table) |
Index Back |
|---|---|
MP - External Payment StateMP - External Payment 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 | PROCESS_MAN_CLOSE | Character(1) | VARCHAR2(1) NOT NULL |
Process Manual Close
N=No P=Processed Y=Yes |
| 3 | MANUAL_CLOSE_DT | Date(10) | DATE | Manual Close Date |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 7 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 8 | DOC_SEQ | Character(1) | VARCHAR2(1) NOT NULL | Enable Document Sequencing |
| 9 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 10 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
| 11 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 12 | JRNL_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Journal Type |
| 13 | JRNL_CODE | Character(8) | VARCHAR2(8) NOT NULL | Journal Code |
| 14 | SEQ_BY | Character(1) | VARCHAR2(1) NOT NULL |
Sequence By
C=Journal Code D=Document Type |
| 15 | SEQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Document Sequencing Type
A=Automatic Numbering M=Manually Entered |
| 16 | SEQ_RANGE_ID | Character(2) | VARCHAR2(2) NOT NULL | Sequence Range |
| 17 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 18 | SEQ_NBR_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Sequence Number Prefix |
| 19 | SEQ_NBR_START | Number(12,0) | DECIMAL(12) NOT NULL | Start Sequence Number |
| 20 | SEQ_NBR_END | Number(12,0) | DECIMAL(12) NOT NULL | End Sequence Number |
| 21 | IN_USE_FLAG_T | Character(1) | VARCHAR2(1) NOT NULL | Journal Type in use flag |
| 22 | IN_USE_FLAG_C | Character(1) | VARCHAR2(1) NOT NULL | Journal Code in use flag |
| 23 | IN_USE_FLAG_S | Character(1) | VARCHAR2(1) NOT NULL | Sequence Range in use flag |
| 24 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 25 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 26 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 27 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |