FACILITIES WORKORDER DETAIL Table
Facilities workorder detail
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
The paid dollar amount of the line item. |
NUMBER |
11 |
COMMITMENT_AMOUNT |
The dollars committed (set aside) but not yet paid for the line item. |
NUMBER |
11 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
This key is to be used to join the FINANCIAL_DETAIL and the PROJECT or PROJECT_OSP tables. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
11 |
DEBIT_CREDIT_INDICATOR |
A one-character flag that identifies whether the line item is a debit or credit. Values are D or C. |
VARCHAR2 |
1 |
DOCUMENT_DATE |
The date entered by the user when creating the document. Generally the date the financial transaction occurred, but see also the definition for document line date. |
DATE |
8 |
DOCUMENT_ENTRY_DATE |
The date the document was entered into SAP. |
DATE |
8 |
DOCUMENT_LINE_DATE |
If not blank, the date the financial transaction occurred. If blank, the document date is the date the financial transaction occurred. |
date |
8 |
DOCUMENT_LINE_ITEM |
Document Line Item Number. |
NUMBER |
3 |
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Key used to join the Document Type to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
FUND_CENTER_KEY |
Key used only for joining the FINANCIAL_DETAIL table with other tables, NOT for reporting. |
VARCHAR2 |
16 |
FUND_KEY |
Key is used only for joining the FUND table with the FINANCIAL_DETAIL table, NOT for reporting. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
LINE_ITEM_TEXT |
The short description of the line item. Also appears on the SAP DTR for the cost collector associated with this financial detail. |
VARCHAR2 |
50 |
OFFSET_COST_COLLECTOR_KEY |
"Offset Cost Collector" is a field referring to a WBS element subject to Underrecovery of F&A costs. The Offset Cost Collector Key in the Financial Detail table can be joined to the Cost Collector Key in Cost Collector tables in queries related to tracking underrecovery of F&A costs. It is used only for joining tables, not on the Request line. |
VARCHAR2 |
12 |
POSTING_DATE |
The date the financial document was posted in SAP. Effective date of posting, not actual date. For example, a costing sheet posting could be generated in early July, but posted to June 30, if so specified by an authorized users. |
DATE |
8 |
POSTING_KEY |
Key required by SAP for each document line item, indicating the type of posting represented in the line item. "Posting Key" is the description for "Posting Key Code". |
VARCHAR2 |
3 |
PO_QUANTITY |
The ordered quantity on a PO line item. |
NUMBER |
22 |
PO_UNIT_OF_MEASURE |
Identifies the unit by which the ordered quantity of a Purchase Order Line Item is measured. Example: each, box, dozen, gallon, case. |
VARCHAR2 |
3 |
PURCHASE_ORDER_ACCT_ASSIGNMENT |
XXX |
NUMBER |
22 |
PURCHASE_ORDER_ITEM |
Number identifying a line item associated with a purchase order. |
NUMBER |
5 |
PURCHASE_ORDER_NUMBER |
Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document. |
VARCHAR2 |
10 |
REFERENCE_DOCUMENT_NUMBER |
For FINANCIAL_DETAIL: The reference number of the associated financial document. A value of %N means that there is no backup for the journal voucher. For COMMITMENT tables, the document number from which the commitment was generated. |
VARCHAR2 |
16 |
REFERENCE_TEXT |
The document header text associated with a journal document. Not always completed by the JV document creator. |
VARCHAR2 |
25 |
SPECIAL_GL_INDICATOR |
XXX |
VARCHAR2 |
1 |
SPECIAL_GL_TRANS_TYPE |
The special G/L transaction type groups together similar special G/L transactions. |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
12 |
VENDOR_KEY |
Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
11 |
VENDOR_NAME |
In the Financial Detail Table, the Vendor to whom a Purchase Order was issued. |
VARCHAR2 |
144 |