PROCESS_INSTANCEO=Organization
P=Person
SSF_APPLINV_AET(SQL Table) |
Index Back |
|---|---|
Aet record for SSF_APPLYINVThis record is used by SSF_APPLYINV to pre-populate the table SSF_ITEM_INV. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SSF_EURO_INVOICING | Character(1) | VARCHAR2(1) NOT NULL | Apply Payments by Invoice |
| 3 | SSF_PRECONV_INV_ID | Character(22) | VARCHAR2(22) NOT NULL | Pre-conversion Invoice ID |
| 4 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | ITEM_NBR | Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
| 7 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 8 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 9 | AMT_REMAINING | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Remaining Amount of Payment |
| 10 | LINE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Line Amount |
| 11 | ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 12 | APPLIED_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Applied Amount |
| 13 | SSF_RECORD_CNT | Number(12,0) | DECIMAL(12) NOT NULL | Record Count |
| 14 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 15 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 16 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |