AMBI_INTFC_BILL(SQL Table) |
Index Back |
|---|---|
AM Bill InformationAM Billing Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUS_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: SP_BOOK_NONVW |
| 4 | DTTM_STAMP |
DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 6 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 7 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 8 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Sequence
Prompt Table: BI_LINE |
| 9 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 10 | AM_TRAN_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Track the sale transaction status in AM
C=Asset Complete G=Asset Ignore I=Asset Processing P=Asset Pending |
| 11 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 12 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table: AMBI_GL_BU_VW |
| 13 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 14 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: AM_GL_BU_VW |
| 15 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_TBL_VW3 |
| 16 | ASSET_ID_TO | Character(12) | VARCHAR2(12) NOT NULL |
Asset ID to
Prompt Table: AM_BOOK_VW |
| 17 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cost Type
Prompt Table: AM_COST_TYPE_VW |
| 18 | AM_BILL_LOAD | Character(3) | VARCHAR2(3) NOT NULL |
Populate the bill load status in Billing
NEW=New PND=Pending RDY=Ready |
| 19 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |