Table SVCRINVCNDD
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SVCRINVCNDD | SVICD | Scheduled invoice | Sales |
Key | Description | Duplicates | Activity code |
---|---|---|---|
SVICD0 | VCRTYP+VCRNUMORI+VCRLINORI+VCRSEQORI+VCRINVCNDLIN | No | |
SVICD1 | VCRTYP+VCRNUMORI+VCRLINORI+VCRSEQORI | Yes | |
SVICD2 | VCRTYP+VCRNUMORI | Yes | |
SVICD3 | VCRTYP-VCRNUMORI+VCRLINORI+VCRSEQORI+VCRINVCNDLIN | No | |
SVICD4 | VCRNUMORI+VCRLINORI+NEXINVDAT+VCRINVCNDLIN | Yes | |
SVICD5 | SVICNUM+VCRINVCNDLIN | No | |
SVICD6 | VCRTYP+VCRNUMORI+VCRLINORI+VCRSEQORI+NEXINVDAT-INVCNDQTY+VCRINVCNDLIN | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AMT_CONS_GRP | MC1 | |||||||
AUUID | Single identifier | AUUID | ||||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[SVICD]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[SVICD]CUR | Block | ||||
DESAXX | Reason | AX3 | ||||||
DNETPRIATI | Net price + tax | MD8 | ||||||
DNETPRINOT | Net price - tax | MD8 | ||||||
INVCNDAMTATI | Amount + tax | MC1 | ||||||
INVCNDAMTNOT | Amount - tax | MC1 | ||||||
INVCNDLIN | Invoicing term line | L | 8 | |||||
INVCNDQTY | Quantity | QTY | ||||||
INVCNDSTA | Status | M | 15 | 2419 | ||||
INVPERCENT | Percentage | DCB | 3.4 | |||||
IS_CONS_GRP | M | 4 | 1 | |||||
IS_EXTRABILL | Excess | M | 5 | 1 | ||||
IS_RES_SPLIT | Split | M | 4 | 1 | ||||
LINORI_SPLIT | Origin line | L | 8 | |||||
LIN_CN_AMT | Amount | MC1 | ||||||
LIN_CN_QTY | Quantity | QTY | ||||||
LIN_EXT_AMT | Amount | MC1 | ||||||
LIN_EXT_QTY | Quantity | QTY | ||||||
LIN_INV_PRI | Price | MD8 | ||||||
LIN_REI_QTY | Quantity | QTY | ||||||
MODDAT | Change date | D | ||||||
MODFLG | Modification | M | 15 | 2421 | ||||
NEXINVDAT | Next invoice | D | ||||||
PERFROM | Period start | D | ||||||
PERTO | Period end | D | ||||||
PJTMST | Milestone project | PJTSI | [PIM]PIM0=[SVICD]PJTMST | Block | PJM | |||
PRC_CONS_GRP | DCB | 3.4 | ||||||
PRGBILLIN | Project status no. | L | 8 | PJM | ||||
PRGBILNUM | Billing plan number | PBIL | [PBILH]PBILH0=PRGBILNUM;PRGBILLIN | Other | PJM | |||
QTY_CONS_GRP | QTY | |||||||
SAU | Sales unit | UOM | [TUN]TUN0=[SVICD]SAU | Block | ||||
SIDLIN | Document line | L | 8 | |||||
SIHNUM | Document number | VCR | ||||||
SVICDNAT | Scheduled invoice category | ADI | [ADI]CODE=205;SVICDNAT | Block | ||||
SVICNUM | Scheduled invoices | VCR | ||||||
TOINVFLG | Billable | M | 4 | 1 | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[SVICD]UPDUSR | Other | ||||
VCRINVCNDLIN | Line number | L | 8 | |||||
VCRLINORI | Source document line | L | 8 | |||||
VCRNUMORI | Original document | VCR | ||||||
VCRSEQORI | Source document sequence no. | L | 8 | |||||
VCRTYP | Entry type | M | 15 | 476 |