SYS_EXPN: AccountView General expressions
read only per partition
- Catalogus:
AccountView - Label: General expressions
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYS_EXPN worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Naam van het beheerbedrijf | |||
ADDRESS |
varchar2 |
Administration business postal address | |||
ADDRESS2 |
varchar2 |
Administration business visiting address | |||
COPIES |
decimal |
Total number of copies | |||
CUR_ |
int64 |
Amount payment method 1 | |||
CUR_ |
int64 |
Amount payment method 2 | |||
CUR_ |
int64 |
Amount payment method 3 | |||
CUR_ |
int64 |
Amount payment method 4 | |||
DATE |
datetime |
Date | |||
LOGIN_ |
varchar2 |
Full name of logged-in user | |||
LONG_ |
varchar2 |
System date in full | |||
PAGENUMBER |
decimal |
Paginanummer | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PAY_ |
int64 |
Deposit amount | |||
PAY_ |
varchar2 |
Currency payment method 1 | |||
PAY_ |
varchar2 |
Currency payment method 2 | |||
PAY_ |
varchar2 |
Currency payment method 3 | |||
PAY_ |
varchar2 |
Currency payment method 4 | |||
PAY_ |
varchar2 |
Payment method 1 | |||
PAY_ |
varchar2 |
Payment method 2 | |||
PAY_ |
varchar2 |
Payment method 3 | |||
PAY_ |
varchar2 |
Payment method 4 | |||
SI_ |
varchar2 |
Sales price per piece sales invoice lines | |||
SI_ |
varchar2 |
Quantity to invoice sales invoice lines | |||
SOL_ |
varchar2 |
Sales price per piece sales order lines (layout) | |||
SOL_ |
varchar2 |
Quantity to deliver sales order lines (layout) | |||
SOL_ |
varchar2 |
Quantity ordered sales order lines (layout) | |||
TIME |
varchar2 |
Time | |||
TOT_ |
int64 |
Paid | |||
TRIAL |
varchar2 |
Draft document | |||
TXT_ |
varchar2 |
Visiting address text | |||
VAT_ |
int64 |
VAT amt code 1 sales order lines (layout) | |||
VAT_ |
int64 |
VAT amt code 2 sales order lines (layout) | |||
VAT_ |
int64 |
VAT amt code 1 sales invoice lines | |||
VAT_ |
int64 |
VAT amt code 2 sales invoice lines | |||
VAT_ |
int64 |
Net amt VAT code 1 sales order lines (layout) | |||
VAT_ |
int64 |
Net amt VAT code 2 sales order lines (layout) | |||
VAT_ |
int64 |
Net amt VAT code 1 sales invoice lines | |||
VAT_ |
int64 |
Net amt VAT code 2 sales invoice lines | |||
VAT_NR |
varchar2 |
Company fiscal VAT number |