[Home] [Help] [Dependency Information]
Object Name: | AR_PMTS_INTERFACE_LINE_DETAIL# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSMISSION_REQUEST_ID | NUMBER | (15) | Yes | |
TRANSMISSION_RECORD_ID | NUMBER | (15) | Yes | |
STATUS | VARCHAR2 | (30) | Yes | |
INVOICE_NUMBER | VARCHAR2 | (50) | Yes | |
APPLY_TO | VARCHAR2 | (150) | Yes | |
ALLOCATED_RECEIPT_AMOUNT | NUMBER | |||
LINE_AMOUNT | NUMBER | |||
TAX | NUMBER | |||
FREIGHT | NUMBER | |||
CHARGES | NUMBER | |||
LINE_DISCOUNT | NUMBER | |||
TAX_DISCOUNT | NUMBER | |||
FREIGHT_DISCOUNT | NUMBER | |||
COMMENTS | VARCHAR2 | (2000) | ||
AMOUNT_APPLIED | NUMBER | |||
CUSTOMER_TRX_ID | NUMBER | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSMISSION_REQUEST_ID
, TRANSMISSION_RECORD_ID
, STATUS
, INVOICE_NUMBER
, APPLY_TO
, ALLOCATED_RECEIPT_AMOUNT
, LINE_AMOUNT
, TAX
, FREIGHT
, CHARGES
, LINE_DISCOUNT
, TAX_DISCOUNT
, FREIGHT_DISCOUNT
, COMMENTS
, AMOUNT_APPLIED
, CUSTOMER_TRX_ID
FROM AR.AR_PMTS_INTERFACE_LINE_DETAIL#;
|
|
|